A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation.
This is a guide on how to reset the default Postgres user password. This should hopefully help you resolve this issue on your test Postgres environment.
Resetting the local default postgres user password includes the following steps:
– Open the Postgres pg_hba config file.
– Amend the authentication method to allow local connectivity.
– Update Postgres User password.
– Revert the change in pg_hba.config file once verified.
How to Reset Postgres User Password
1. Open your pg_hba.conf file which can be found in your data directory.
Default Path: C:\Program Files\PostgreSQL\10\Data
2. Change the method within the pg_hba.conf file as highlighted below, from md5 to trust.
3. Restart the postgresql service.
4. Open psql in your terminal, connect and execute the ALTER USER SQL Statement as shown below.
5. Now open pgAdmin, you should be able to log back in with the ‘postgres’ user.
Leave a Reply