Tell me more ×
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. It's 100% free, no registration required.
up vote 3 down vote favorite

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.

Thoughts?

share|improve this question
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

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

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

1 Answer

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 http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

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

share|improve this answer

Your Answer

 
discard

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.