> 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, you can't retrieve it. You can change it, though, as the postgres user:
ALTER USER the_user WITH PASSWORD 'new_password';
______AGLIO DATABASE SOLUTIONS___________________________
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
In response to
pgsql-novice by date
|Next:||From: Ron Johnson||Date: 2002-05-19 20:10:30|
|Subject: Re: Is a randomized default value primary key possible?|
|Previous:||From: thiemo||Date: 2002-05-19 18:03:09|
|Subject: Re: Forgotten the master password of db |