PostgreSQL Reset Password

If you can’t remember your password you will need to disable authentication temporarly, login and reset the password.

Go into your pgdata directory.

Open pg_hba.conf

The lines that say “md5” near the bottom, change to “trust”

Restart your database instance.

Login and set your password.

alter user vu2131 with password 'foobar';

Quit psql.

Change the lines back to md5 in your pg_hba.conf file

Restart your instance again.

Try logging in and see if your change worked!