PostgreSQL: How to change PostgreSQL user password?

Question

How do I change the password for the PostgreSQL user?

Answer 1

In order to login without a password:

sudo -u user_name psql db_name

To reset the password if you don't remember:

ALTER USER user_name WITH PASSWORD 'new_password';

Want to acquire SQL Expertise? Register now to this SQL Course and get certified.