Menu
I just installed PostgreSQL 9.2 from enterprisedb onto Mac OS X 10.8.2. I mistyped my postgres user password, so I can't connect. How do I reset the password?
947
If you don't remember your PostgreSQL database password, you can follow the steps below to reset it to a new value: Change the authentication method in the PostgreSQL configuration file pg_hba. conf from md5 to trust and reload the configuration. You should now be able to connect to PostgreSQL with the new password.
For most systems, the default Postgres user is postgres and a password is not required for authentication. Thus, to add a password, we must first login and connect as the postgres user.
Found directions:
sudo su postgres modify /Library/PostgreSQL/9.2/data/pg_hba.conf
-local all all md5 +local all all trust restart postgres
/Library/PostgreSQL/9.2/bin/pg_ctl restart -D /Library/PostgreSQL/9.2/data/ Connect to postgres:
psql Inside psql (\q to quit):
ALTER USER postgres WITH ENCRYPTED PASSWORD 'password'; modify pg_hba.conf back
+local all all md5 -local all all trust restart postgres
/Library/PostgreSQL/9.2/bin/pg_ctl restart -D /Library/PostgreSQL/9.2/data/ If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With