+2 votes
in Databases by (75.1k 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

+1 vote
by (353k points)
selected by
Best answer

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

ALTER USER user_name WITH PASSWORD 'new_password';