Change/reset postgresql user password on windows 7

Below steps helped me to reset the password-

Go to pg_hba.conf file at path e.g. C:\Program Files\PostgreSQL\10\data and add below line at the end,
```
host all postgres 127.0.0.1/32 trust
```
Restart the PostgreSQL service from services control panel (start -> run -> services.msc)
Connect using PgAdmin or any software that you prefer and run query,
```
ALTER USER postgres PASSWORD 'postgres'
```
Remove the line that you added in step 1.
Restart PostgreSQL.

In the pg_hba.conf file, change (temporarily) all METHOD with trust. EG :

host    all             all             ::1/128                 trust

instead of :

host    all             all             ::1/128                 md5

You can find where the pg_hba.conf is located by typing in a psql command line:

SHOW hba_file;

Run your psql executable file and login into your database using your old password, use the following command to login:

 .\psql.exe -U postgres

Then use

ALTER USER <user_name> WITH PASSWORD <'new_password'>

For more information refer this link : https://www.postgresql.org/docs/8.0/sql-alteruser.html

Edit pg_hba.conf to allow you to connect without a password. Then use ALTER USER to reset the password. Then change pg_hba.conf back again.

For the documentation on pg_hba.conf, see here:

http://www.postgresql.org/docs/devel/static/auth-pg-hba-conf.html

Related