15

This question already has an answer here:

I have installed PostgreSQL on my Windows machine for development. Now I haven't used it for a while, and have forgotten the password for user postgres (default admin user in PostgreSQL). How can I reset the password for postgres in PostgreSQL on Windows?


I followed Milen's suggestion, but got this message when trying to reload the configuration file:

C:\Program Files\PostgreSQL\9.1\data>pg_ctl reload -D .
pg_ctl: could not send reload signal (PID: 3396): Operation not permitted

In Windows there is a menu option "Reload Configuration" that worked better, as shown below:

enter image description here

marked as duplicate by Evan Carroll, joanolo, Paul White Mar 10 '17 at 4:38

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

18

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

  1. Edit pg_hba.conf to allow trust authorization temporarily - go here for its location
  2. Reload the config file (pg_ctl reload)
  3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
  4. Edit pg_hba.conf again and restore the previous settings
  5. Reload the config file again
  • 2
    Can you explain Reload the config file (pg_ctl reload)? How do you do that? – CodyBugstein Aug 25 '14 at 2:22
  • Run 'pg_ctl' as windows root authentication – 안재형 Mar 3 '17 at 5:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.