How to reset user’s password in PostgreSQL using Terminal
Assalamualaikum,
A quick solution to reset PostgreSQL user’s password.
Just run following commands after open up the terminal window:
- sudo su – postgres
- psql -d template1
- template1=# ALTER USER postgres WITH PASSWORD ‘some password’g
- template1=# q
Then login as usual. 🙂
p/s: I’m using psql 9.1 & ubuntu 12.04 LTS. 🙂
Regards,
Nas