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?

reza
  • 143
  • 1
  • 3

1 Answers1

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.