Munyutu Waigi wrote: > We desperately need assistance to regain access to our DB, TSAOMS Droplet. > Our developer (Fred Omala) has gone AWOL and our clients cannot access our solution. If local connections are allowed "trust" or "peer" authentication in pg_hba.conf, log into the database server as user "postgres" and start "psql". Then you can use ALTER ROLE to change database passwords. If all fails, you'll have to stop the database server and start it in single user mode (as operating system user "postgres"): postgres --single -D /your/database/directory postgres Then you are connected with superuser permissions and can change passwords. If all that is too complicated for you, contact a support company. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
