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.


migrated from stackoverflow.com Nov 18 '11 at 15:51

This question came from our site for professional and enthusiast programmers.

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

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, privacy policy and cookie policy

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