| From: | Gowri Sivaraman <gsivaraman(at)magnasync(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_hba.conf |
| Date: | 2006-02-21 19:39:38 |
| Message-ID: | 229be82fef34690094034e04c7c4e0fd@magnasync.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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=>
| Attachment | Content-Type | Size |
|---|---|---|
| pg_hba.conf | application/octet-stream | 8.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Durham | 2006-02-21 20:57:06 | binary data types and streaming |
| Previous Message | richard.hardgrave | 2006-02-21 16:39:29 | Installing my PostgreSQL client |