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

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

ALTER USER user_name WITH PASSWORD 'new_password';