PostgreSQL: How to change PostgreSQL user password?

To login without a password:

sudo -u user_name psql db_name

To reset the password if you have forgotten:

ALTER USER user_name WITH PASSWORD 'new_password';

postgresql change-password

To change the the postgres user's password follow this steps

$ sudo -u postgres psql

postgres=# \password postgresEnter new password: <new-password>postgres=# \q

or using a query

ALTER USER postgres PASSWORD '<new-password>';

or in one line

sudo -u postgres psql -c "ALTER USER postgres PASSWORD '<new-password>';"

If that does not work, reconfigure authentication by editing /etc/postgresql/9.1/main/pg_hba.conf (path will differ) and change:

local   all         all                  peer # change this to md5## tolocal   all         all                  md5 # like this

Then restart the server:

$ sudo service postgresql restart

postgresql change-password

You can and should have the users's password encrypted:

ALTER USER username WITH ENCRYPTED PASSWORD 'password';

CodeHunter