How to Change a Postgres User Password

February 11, 2015 Developer Tools

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Changing a PostgreSQL user password is accomplished using the “postgres” command prompt. Here is the instruction to tell you how to change a Postgres User Password. 3

1. Click “Start” and enter “cmd” in the search bar, click “Enter” to open the command prompt window.

1

2. Enter the command “psql -h -U ”. Replace "" with the network or IP address of the PostgreSQL server and "" with the name of your Super User account.

2

3. Change the password of the PostgreSQL user. Type “ALTER USER WITH PASSWORD '' ”. Now you’ve successfully change the password.