CODEWITHSUNDEEP
postgresqlwindows-7
Oto Shavadze
Oto Shavadze

Reputation: 42853

Change/reset postgresql user password on windows 7

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?

Upvotes: 30

Views: 110746

Answers (6)

Hetal Rachh
Hetal Rachh

Reputation: 1543

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.

Upvotes: 23

AfriPwincess
AfriPwincess

Reputation: 183

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

  1. I opened the windows command prompt and typed: psql -U postgres(postgres is my username)

  2. Type in your current password

3 Then type: \password postgres

enter image description here

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.

Upvotes: 10

Antoine Martin
Antoine Martin

Reputation: 1953

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;

Upvotes: 56

Shivam_kira
Shivam_kira

Reputation: 109

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

Upvotes: 3

Shubham Singh
Shubham Singh

Reputation: 211

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.

Upvotes: 2

Ben
Ben

Reputation: 35663

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

Upvotes: 11

Related Questions