Step 1 : Run following command change the authentication method in the configuration file and then reload
sudo sed -ibak 's/^\([^#]*\)md5/\1trust/g' pg_hba.conf
/etc/init.d/postgresql reload
Step 2 : Once the authentication method is reset then you can login to postgres using following and set the new password value
psql -U postgres
postgres=# alter user postgres with password 'NEW_PASSWORD';
postgresl=# \q
Step 3 : Once the new password is set, change the authentication method back to md5
sudo sed -i 's/^\([^#]*\)trust/\1md5/g' pg_hba.conf sudo -u postgres pg_ctl reload or /etc/init.d/postgresql reload
You are all set to login using your new password
No comments:
Post a Comment