We have users for out postgres database and none have passwords... Do not know the history behind it.

When I try to use clients to connect to these databases, for instance, pgadmin III, the connection always fails due to the lack of password.

How does one overcome this? I do not want to create username with passwords just to get around this. Sometimes that is not an option.


  • 1
    What is the mode currently being used in pg_hba.conf, is it trust or ident, or something else?
    – skyhisi
    Commented Nov 18, 2011 at 9:06
  • you are correct that this is the settings I need to change also the md5 one
    – reza
    Commented Nov 18, 2011 at 18:35
  • similar question Commented Nov 19, 2011 at 12:03

1 Answer 1


Do you have administrative access to the database?

If so you can edit pg_hba.conf to adjust access control configuration. See http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

After you make changes issue pg_ctl reload or restart the database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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