postgresql - 如何更改PostgreSQL用户密码？(How to change PostgreSQL user password?)

Question

如何更改PostgreSQL用户的密码？

  ask by Saad translate from so

Answer 1

For password less login:

(对于少密码登录：)

sudo -u user_name psql db_name

To reset the password if you have forgotten:

(要忘记密码，请重设密码：)

ALTER USER user_name WITH PASSWORD 'new_password';