thiemo <thiemo(at)gmx(dot)ch> writes:
> unfortunately I have forgotten the mpassword of the master user of a db.
> 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.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: thiemo||Date: 2002-05-19 18:03:09|
|Subject: Re: Forgotten the master password of db |
|Previous:||From: April L||Date: 2002-05-19 16:10:04|
|Subject: Is a randomized default value primary key possible?|