Psql

Change password for postgres user in PostgreSQL

In order to change the password for the postgres user you should NEVER do this:

$ sudo passwd postgres

By default the postgres user is locked and if you change the password with passwd the account…