Postgres Pro
Downloads
Home   >   mailing lists

Fwd: resetting superuser password - Mailing list pgsql-admin

From Marc A. Donis
Subject Fwd: resetting superuser password
Date
Msg-id E1EZpDc-0001mP-2c@garm.runbox.com
Whole thread Raw
Responses Re: Fwd: resetting superuser password  (Devrim GUNDUZ <devrim@gunduz.org>)
Re: Fwd: resetting superuser password  (Martin Fandel <martin.fandel@alphyra-evs.de>)
List pgsql-admin
Tree view 
I have lost the superuser (user postgres) password, but I still have the unix root password.  Is there anything I can
doto reset the postgres user's password (short of reinstalling Postgres)? 

Obviously, I can su to unix user postgres, but this does not seem to advance my cause, as doing "psql -U postgres"
stillprompts me for a password, which is not the same as the unix postgres user's password.  

OS: RedHat 9

Help!

Thanks,
Marc

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Open connections details
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Fwd: resetting superuser password