How to Change the PostgreSQL Administrator Password

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

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.

Solution

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 :

    (Auto-migrated image: description temporarily unavailable)

  4. Change the "md5" method to "trust" and save the file as described in the screenshot below:

    (Auto-migrated image: description temporarily unavailable)

  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!

Updated on April 7, 2025
Platform
Data Center only
Product
Confluence Data Center
On this pageSummarySolution

Still need help?

The Atlassian Community is here for you.
Ask the Community