+2 votes
in Databases by (12.4k points)
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?

1 Answer

0 votes
by (22k points)

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

ALTER USER user_name WITH PASSWORD 'new_password';