How to Change The ‘Postgres’ User Password

Log in as root

su postgres
psql -d template1 -U postgres
alter user postgres with password 'newpassword';
\q

Then as root run ‘passwd postgres’ and reset the password there as well in order to enable the login from command line.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *