4

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?

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

1 Answer 1

3

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.

answered Nov 17, 2011 at 19:38

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.