Postgresql password cannot login

Question

I typed the following instruction to set up the postgresql password.

sudo su - postgres
psql -U postgres
alter user postgres with encrypted password 'my_pass';
\q
sudo su - postgres

But I met the error.

[sudo] password for postgres:my_pass

Sorry, try again.

Which thing did I miss?

I actually set the password.

Thanks.

alter user is sql command while sudo su - postgres is OS - users are different for os and database. accordingly passwords are. use passwd for OS postgres password — Vao Tsun
– Vao Tsun, Commented Mar 20, 2017 at 15:42
edit question. leave only steps what you did and clearly defined goal please — Vao Tsun
– Vao Tsun, Commented Mar 20, 2017 at 15:57
So should I change into alter user postgres with encrypted passwd 'my_pass';? But I can't login to execute the statement. — Jonathan Cheng
– Jonathan Cheng, Commented Mar 20, 2017 at 16:10
what are trying to achieve? to set the password for os user or for db user? — Vao Tsun
– Vao Tsun, Commented Mar 20, 2017 at 16:11
I edited the question.I want to change the original os user postgres's password — Jonathan Cheng
– Jonathan Cheng, Commented Mar 20, 2017 at 16:16

Vao Tsun · Accepted Answer · 2017-03-20 16:20:28Z

11

to change os user password, run sequentially:

sudo su -

passwd postgres

and enter a new password.

Keep in mind that if you are a sudo user, you wont be asked for a password anyway...

answered Mar 20, 2017 at 16:20

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

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

2 Comments

Chris Over a year ago

I am in a similar situation, however when I type "sudo su -" it asks me for postgres password... any idea what I could do in this case?

Vao Tsun Over a year ago

because postgres is not sudo user. and you dont need sudo su if you are postgres - just run passwd. Also if you are posttgres, why do U want to change the password? apparently you know it if you login...

Collectives™ on Stack Overflow

Postgresql password cannot login

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related