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