I recently forgot my PostgreSQL 9.1 password on my windows 8 and it asks for password on pgAdmin III console.
Can I retrieve the password or reset it?
After researching, I found that we need to find the pg_hba.conf file under
Open the file and at the very bottom, look for
# TYPE DATABASE USER ADDRESS METHOD
For all the entries for TYPE host, change the METHOD from md5 to trust. Save the file. (Make sure there are no interactions with the database at this moment.)
Press Windows+R to get the run dialog, type services.msc and press enter.
Choose File->Change password to change the password (old password would be a default of postgres).
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
2 years ago