>> unfortunately I have forgotten the mpassword of the master user of a
>> Is there a way to retrieve it using the user who owns the db template1?
> No, but you can temporarily set the authorization policy (pg_hba.conf)
> to something other than password; log in as the superuser without any
> password; assign yourself a new password.
I shall try so.
In response to
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2002-05-19 18:59:57|
|Subject: Re: Forgotten the master password of db|
|Previous:||From: Tom Lane||Date: 2002-05-19 16:45:59|
|Subject: Re: Forgotten the master password of db |