Set postgres user password on windows

Question

I would like to set a password for the postgres user on my local database on windows.

Currently I can login to postgres using "psql -U postgres" without the need for a password

My pg_hba file is as follows

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

I've tried alter user postgres with password ... but this didn't make any difference. — user913059
– user913059, Commented Aug 27, 2015 at 10:21

Tom-db · Accepted Answer · 2015-08-27 12:46:50Z

4

First login as usual with psql -U postgres and set a password for the user postgres:

ALTER USER postgres PASSWORD 'your-new-password';

Than edit you file pg_hba.conf and add this line:

local   all             postgres                                   md5

Finally restart the postgres server.

answered Aug 27, 2015 at 12:46

Tom-db

6,9584 gold badges33 silver badges51 bronze badges

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

7 Comments

user913059 Over a year ago

postgres doesn't seem to restart, do I need to put an address?

Tom-db Over a year ago

Do you mean, the restart fails? With a error message?

user913059 Over a year ago

I'm restarting from the windows task manager - services section, it says stopped in the status when trying to restart

Tom-db Over a year ago

Probably you made a error by editing the file pg_hba.conf

user913059 Over a year ago

I don't think "local all postgres md5" works on windows

|

Berkay · Accepted Answer · 2022-02-27 23:12:42Z

0

edit pg_hba.conf file: instead 'md5' use 'trust'. this is for connecting your postgresql server.
reload postgresql
pgAdmin4 has an user interface for this. look belove👇👇 provide your new password here.
restore pg_hba.conf file then reload postgresql. DONE it worked for me.

if you do these things by using command prompt. pay attention this

ALTER USER postgres PASSWORD 'your-new-password';

it could be like

ALTER ROLE postgres PASSWORD 'your-new-password';

because when i look at the postgres from pgAdmin4 it look like a role not user. look at this ss

answered Feb 27, 2022 at 23:12

Berkay

3503 silver badges11 bronze badges

Collectives™ on Stack Overflow

Set postgres user password on windows

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related