How to Change the PostgreSQL Administrator Password

Still need help?

The Atlassian Community is here for you.

Ask the community

There may be a time when you forget your PostgreSQL administrator password. The process below describes how you can log in without a password to change the password of PostgreSQL.

How to Log In to PostgreSQL Without a Password

  1. Search for pg_hba.conf which should be located in C:\Program Files\PostgreSQL\9.3\data
  2. Right click and edit pg_hba.conf using a text editor 

  3. Scroll down the text file and you will see something as described in the screenshot below :
  4. Change the "md5" method to "trust" and save the file as described in the screenshot below:
  5. Login to PostgreSQL using pgAdmin, without a password
  6. From there on you should be able to go to the UI and change the password
  7. Edit pg_hba.conf using a text editor and change "trust" back to "md5"
  8. Password is now changed!

 

Last modified on Oct 7, 2015

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.