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 http://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation which has a more explanitive answer ;) — TimoSolo, Apr 15 '14 at 08:46
https://dba.stackexchange.com/questions/44586/forgotten-postgresql-windows-password — Devesh, Jun 07 '18 at 07:33
Check this link: [forgotten-postgresql-windows-password](https://dba.stackexchange.com/questions/44586/forgotten-postgresql-windows-password) **It is work for me** — Ramil Aliyev 007, Jan 28 '20 at 11:24

Antoine Martin · Answer 1 · 2019-03-27T23:32:26.450

55

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 '19 at 23:32

answered Jun 01 '14 at 11:52

Antoine Martin

1,903
2
16
28

9

Dont forget to restart service – themadmax Apr 01 '15 at 18:21

score 19 · Answer 2 · edited Apr 01 '19 at 18:38

19

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 Apr 01 '19 at 18:38

answered Apr 01 '19 at 18:36

Hetal Rachh

1,393
1
17
23

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 Mar 08 '20 at 19:35
I think you should replace the "host xxx md5" line. Only adding did not worked for me. – Pedro77 Mar 08 '20 at 19:44

score 12 · Accepted Answer · edited Sep 03 '13 at 09:00

12

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 03 '13 at 09:00

splash

13,037
1
44
67

answered Sep 03 '13 at 08:52

Ben

34,935
6
74
113

10

Edit how? I have no idea what to put or remove from that file. – icl7126 Nov 01 '13 at 22:23
2

@klerik, the link is to the manual page for pg_hba.conf. It explains everything about pg_hba.conf. – Ben Nov 02 '13 at 10:15
8

Note that in Windows the `pg_hba.con` file is under the `data` folder, e.g. `C:\Program Files\PostgreSQL\9.3\data` – xji Dec 18 '17 at 20:38
Still get an error even after making a new password – Matt Sep 10 '18 at 01:58
3

Very bad explained answer. I don't know how it got 14 votes. – Pedro77 Mar 08 '20 at 19:23
How does one edit the pg_hba.conf file to allow you to connect without a password? The explanation was very vague and am not sure how it got the upvotes. – AfriPwincess Oct 18 '21 at 13:43

score 4 · Answer 4 · answered Oct 18 '21 at 14:16

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.

score 3 · Answer 5 · edited Feb 06 '19 at 10:43

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 06 '19 at 10:43

balintbabics

1,291
2
11
25

answered Jan 28 '19 at 08:20

Shivam_kira

109
3

1

IF you can still login (hence haven't forgotten your password), this is probably the easiest and most save. – James John McGuire 'Jahmic' Feb 24 '19 at 09:29

Shubham Singh · Answer 6 · 2018-01-08T13:09:36.203

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 08 '18 at 13:09

answered Sep 19 '17 at 09:40

Shubham Singh

213
2
13

4

I wasn't able to find this file nor the `postgresql` folder in my Roaming folder though. – xji Dec 18 '17 at 20:33
thank you, I was able to find the file 'pgpass.conf' in another user's folder – Harlan Gomes Nascimento Jan 29 '19 at 13:55

Change/reset postgresql user password on windows 7

6 Answers6

Linked