How to reset the password for PostgreSQL user

We can use the following method to reset password for PostgreSQL user.

First of all login to the PostgreSQL shell as admin user.

Then run the following query.

> ALTER USER username WITH PASSWORD 'password';

Here we need to replace username and password with the required values.

That's all…