Postgres Pro
Downloads
Home   >   mailing lists

forgotten data base superuser password - Mailing list pgsql-admin

From Mikhail Utin
Subject forgotten data base superuser password
Date
Msg-id 010d01c084f5$e610f9a0$240bb5d8@noble.rubos.com
Whole thread Raw
Responses Re: forgotten data base superuser password  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
Hi,
I've been developing my site with postgresql as DB engine since 2000. My DB administrator is gone, and I do not know postgresql (DB superuser) account password. The DB is v.6.5.2 and is running on Linux 5.2 kernel.
I can change the account password to blank using my root account, and set it up while logging in as postgresql. Is that right way to change DB superuser forgotten password? I am not sure how the DB uses pg_shadow file, and if it will be synchronized after I changed the password.
Thank you
 
Mikhail A. Utin

pgsql-admin by date:

Previous
From: Stefan Huber
Date:
Subject: Re: Temporary files directory
Next
From: Tom Lane
Date:
Subject: Re: forgotten data base superuser password