- In pg_hba.conf file change line
- restart postgreSQL by /etc/init.d/postgresql restart
- login as postgres by psql -U postgres
- change password by issuing the query ALTER USER postgres with encrypted password 'secret';
- undo changes done in step1
- restart
Last active
August 29, 2015 13:57
-
-
Save valyakuttan/9604634 to your computer and use it in GitHub Desktop.
Reset PostgreSQL's postgres user's password from http://scratching.psybermonkey.net/2009/06/postgresql-how-to-reset-user-name.html
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment