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...

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 reply

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