Featured image of post PostgreSQL pgAdmin reset password

PostgreSQL pgAdmin reset password

  1. Change METHOD of all rows in your pg_hba.conf file from scram-sha-256 to trust
  2. Add bin folder of Postgres installation to path, if you haven’t
  3. Open command prompt and enter psql -U postgres You won’t be asked for password here.
  4. Enter \password postgres
  5. Choose and confirm your password
  6. Revert pg_hba.conf to original state
Built with Hugo
Theme Stack designed by Jimmy