How to change the password of a PostgreSQL user

Question

I created a user for my PostgreSQL database some time ago, but I do not remember the password now. How can I change the password for the user?

Answer 1

After logging to PostgreSQL server, run the following SQL to change the password.

ALTER USER user_name WITH PASSWORD 'new_password';