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

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

ALTER USER user_name WITH PASSWORD 'new_password';