patternsqlMinor
postgres and passwordless authentication
Viewed 0 times
andpasswordlessauthenticationpostgres
Problem
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?
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?
Solution
Do you have administrative access to the database?
If so you can edit
After you make changes issue
If so you can edit
pg_hba.conf to adjust access control configuration. See http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.htmlAfter you make changes issue
pg_ctl reload or restart the database.Context
StackExchange Database Administrators Q#8109, answer score: 3
Revisions (0)
No revisions yet.