Changing the postgres (main) user's PostgreSQL password (pgAdmin 4)
Modified on: Wed, 20 Nov, 2019 at 7:26 AM
To replace a forgotten postgres password with pgAdmin 4:
1. Make a backup copy of your pg_hba.conf file. The default location is C:\ProgramData\Spire\PostgreSQL\10\pg_hba.conf
2. Right-click Notepad in the Start Menu and click "Run as administrator". Open the original pg_hba.conf file.
3. Add these 2 lines to the top of the file and save it. Please make sure the file name and extension don't change.
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
4. Launch pgAdmin 4 then right-click the "Servers" node and click "Create -> Server..." to create a new temporary server entry. Provide a name for your new server on the "General" tab in the "Name" field.
5. Go to the "Connection" tab.
- Enter "localhost" for the "Host" field.
- Make sure the "Username" field specifies "postgres".
- Leave the "Password" field blank.
- Press "Save" when you're ready.
6. Expand your new server entry.
- Expand the "Databases" node.
- Right-click the postgres database.
- Click "Query Tool".
7. Enter the following SQL command into the query editor:
ALTER USER postgres with password 'your_password_here';
- Replace your_password_here with a password of your choice.
- Press F5 when you're ready to run the query.
8. Open the original pg_hba.conf file using a text editor that was started with administrator rights. Remove the 2 lines at the top of the pg_hba.conf file (that were added in step 3) and save the file. Ensure the file name and extension don't change.
Note: If you cannot save changes to the file even if you run the text editor as administrator, you can copy the original file to a secondary backup file and delete the original file. Then, edit the new copy of the file, make the changes, and use the save-as feature to save it back to the original filename.
9. Existing server entries in the pgAdmin 4 interface will no longer work since their saved password is wrong. Add a new server entry with the new postgres password you created in step 7.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.