I am new to QGIS. I forget the DB manager password

enter image description here.

Is there a way to fix it?


Change in your pg_hba.conf file the line for localhost:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             postgres                                trust
host    all             postgres            trust
host    all             postgres        ::1/128                 trust

Restart your postgres instance. It allows you to connect to the database as postgres user from localhost with no password. Start psql and change the password for postgres user and reset your pg_hba.con file.

  • Thanks for your suggestion. Can I also ask where to find the pg_hba.conf file on Mac? – enaJ Dec 4 '16 at 4:35
  • You may need root/superuser rights to edit the file (or to change the access rights) on some OS. – AndreJ Dec 4 '16 at 6:58
  • There is a topic about mac and pg_hba.conf file on stackoverflow: stackoverflow.com/questions/14025972/… – Zoltan Dec 4 '16 at 7:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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