Home / Uncategorized / How to Change The ‘Postgres’ User Password

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 Reply

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

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

  •  
    Previous Post

    The [pretty much] Complete Guide to Installing ffMPEG and Audio Binaries

  •  
    Next Post

    Upgrading to Perl 5.8.8 – cPanel