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.

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.