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 C:\Program Files\PostgreSQL\9.3\data
# 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.)
Choose File->Change password to change the password.(old password would be a default of postgres)
Please feel free to vote, if I could help anyone of you in anyway.
Thanks to this wonderful community!