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?

duplicate of stackoverflow.com/questions/10845998/… which has a more explanitive answer ;) — TimoSolo
– TimoSolo, Commented Apr 15, 2014 at 8:46
Check this link: forgotten-postgresql-windows-password It is work for me — Ramil Aliyev 007
– Ramil Aliyev 007, Commented Jan 28, 2020 at 11:24

Antoine Martin · Accepted Answer · 2019-03-27 23:32:26Z

56

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;

edited Mar 27, 2019 at 23:32

answered Jun 1, 2014 at 11:52

Antoine Martin

1,9833 gold badges16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

themadmax Over a year ago

Dont forget to restart service

MatthewMartin · Accepted Answer · 2024-06-18 01:08:10Z

23

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.

edited Jun 18, 2024 at 1:08

MatthewMartin

33.3k33 gold badges117 silver badges172 bronze badges

answered Apr 1, 2019 at 18:36

Hetal Rachh

1,5531 gold badge20 silver badges25 bronze badges

2 Comments

Pedro77 Over a year ago

I was able to loging using My SQL and run: ALTER USER postgres PASSWORD myPassword. Do I need the ''? Because it didn't work. What worked for me was to login using pgAdmin4 and change inside the server config. After resenting the pg_hba the new password worked.

Pedro77 Over a year ago

I think you should replace the "host xxx md5" line. Only adding did not worked for me.

splash · Accepted Answer · 2013-09-03 09:00:52Z

11

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

edited Sep 3, 2013 at 9:00

splash

13.4k1 gold badge49 silver badges69 bronze badges

answered Sep 3, 2013 at 8:52

Ben

35.8k6 gold badges81 silver badges117 bronze badges

6 Comments

Juraj Over a year ago

Edit how? I have no idea what to put or remove from that file.

Ben Over a year ago

@klerik, the link is to the manual page for pg_hba.conf. It explains everything about pg_hba.conf.

xji Over a year ago

Note that in Windows the pg_hba.con file is under the data folder, e.g. C:\Program Files\PostgreSQL\9.3\data

Matt Over a year ago

Still get an error even after making a new password

Pedro77 Over a year ago

Very bad explained answer. I don't know how it got 14 votes.

|

AfriPwincess · Accepted Answer · 2021-10-18 14:16:50Z

11

I am using postgres version 14.0 and Windows 10. To reset the password:

I opened the windows command prompt and typed: psql -U postgres(postgres is my username)
Type in your current password

3 Then type: \password postgres

It brings up the prompts to type the new password and confirm. Note for the psql command to work on the windows command prompt, you need to set the postgres bin folder on the path environment variable. You can just google how to do this.

answered Oct 18, 2021 at 14:16

AfriPwincess

1932 silver badges7 bronze badges

Comments

canals_bib_bit · Accepted Answer · 2019-02-06 10:43:15Z

3

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

edited Feb 6, 2019 at 10:43

canals_bib_bit

1,2912 gold badges12 silver badges25 bronze badges

answered Jan 28, 2019 at 8:20

Shivam_kira

1191 silver badge3 bronze badges

1 Comment

James John McGuire 'Jahmic' Over a year ago

IF you can still login (hence haven't forgotten your password), this is probably the easiest and most save.

Shubham Singh · Accepted Answer · 2018-01-08 13:09:36Z

2

In windows postgres stores password for automatic login at following path (only if you would have selected password save option while installation)

C:\Users\USERNAME\AppData\Roaming\postgresql\pgpass.conf

you can open this file in a text editor and see your password.

edited Jan 8, 2018 at 13:09

answered Sep 19, 2017 at 9:40

Shubham Singh

2112 silver badges13 bronze badges

2 Comments

xji Over a year ago

I wasn't able to find this file nor the postgresql folder in my Roaming folder though.

Harlan Gomes Nascimento Over a year ago

thank you, I was able to find the file 'pgpass.conf' in another user's folder

Collectives™ on Stack Overflow

Change/reset postgresql user password on windows 7

6 Answers 6

1 Comment

2 Comments

6 Comments

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

2 Comments

6 Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related