Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question

migrated from Nov 18 '11 at 15:51

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

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
up vote 2 down vote accepted

Do you have administrative access to the database?

If so you can edit pg_hba.conf to adjust access control configuration. See

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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