- Edit the pg_hba.conf file
- sudo vi /Library/PostgreSQL/9.2/data/pg_hba.conf
- Change the "md5" method for all users to "trust" near the bottom of the file
- Find the name of the service
- ls /Library/LaunchDaemons
- Look for postgresql
- Stop the postgresql service
- sudo launchctl stop com.edb.launchd.postgresql-9.2
- Start the postgresql service
- sudo launchctl start com.edb.launchd.postgresql-9.2
- Start psql session as postgres
- psql -U postgres
- (shouldn't ask for password because of 'trust' setting)
- Reset password in psql session by typing
- ALTER USER postgres with password 'secure-new-password';
- \q
- enter
- Edit the pg_hba.conf file
- Switch it back to 'md5'
- Restart services again
Monday, December 2, 2013
Resetting PostgreSQL 'postgres' user password in Mac
Subscribe to:
Post Comments (Atom)
10 comments:
Very informative and well written post! Quite interesting and nice topic chosen for the post.
CyberPowerPC Laptops
Nice information
This was really helpful, thanks!
Really useful, thank you for the help!!
Unfit to Retrieve Postgres Password? Contact to Postgres SQL Support for Linux to settle issue
In the event that whenever you experienced this secret word related issue in your Postgres SQL at that point attempt these beneath ventures to take care of this issue: first you need to set the watchword for client Postgres, now you need to change your pg_hba.conf lastly reload the Postgres server. By attempting these means you can undoubtedly take care of your concern yet in the event that as yet having a similar watchword issue at that point contact to Postgres SQL Support for Windows or PostgreSQL Remote Database Service to get the best help.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Really useful, thank you for the help!!
The only clear and working tutorial for Mac Postgres 12 on the internet. 1000 thanks!
Many thanks for working on my postgres 11, really helps !
Amazing tutorial! Still valid 7 years later on Postgres 11 and 13. Thanks very much!
The only working explanation. Step by step. Postgres 13.3
Post a Comment