Change/reset postgresql user password on windows 7

Question

Several days ago I install postgesql 9.2 version on my local computer. (OS windows 7)

Now I forgot my password and I can not login in pgAdmin.

How to change postgresql password on windows 7?

Answer 1

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; 

Answer 2

Below steps helped me to reset the password-

1. 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 

2. Restart the PostgreSQL service from services control panel (start -> run -> services.msc)

3. Connect using PgAdmin or any software that you prefer and run query,

   ALTER USER postgres PASSWORD 'postgres' 

4. Remove the line that you added in step 1.

5. Restart PostgreSQL.