pg_hba.conf
От | Gowri Sivaraman |
---|---|
Тема | pg_hba.conf |
Дата | |
Msg-id | 229be82fef34690094034e04c7c4e0fd@magnasync.com обсуждение исходный текст |
Ответы |
Re: pg_hba.conf
|
Список | pgsql-admin |
Hi, I am having problems with my connectivity for any of the users other than the post gres. Let me elaborate on the situation I am using OSX and i have changed the pg_hba.conf file to reflect ident_authentication. I have attached my pg_hba.conf file. When i try connecting as a user i get the following error Gowri-Sivaraman:~ gowri$ psql -h localhost gen3logger psql: FATAL: Ident authentication failed for user "gowri" Even when i have given the user gowri trust authorization, it is not working. For some reason, it is recognizing local . when i connect using the host it is working. Can anybody let me know if i am missing something here Gowri-Sivaraman:~ gowri$ psql -h 127.0.0.1 -U gowri template1 Welcome to psql 8.1.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) template1=> Thanks Gowri
Вложения
В списке pgsql-admin по дате отправления: