postgres and passwordless authentication

Question

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?

What is the mode currently being used in pg_hba.conf, is it trust or ident, or something else? — skyhisi
– skyhisi, Commented Nov 18, 2011 at 9:06
you are correct that this is the settings I need to change also the md5 one — reza
– reza, Commented Nov 18, 2011 at 18:35

Grzegorz · Accepted Answer · 2011-11-17 19:38:07Z

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

Grzegorz

1 Answer 1