[ADMIN] pg_hba.conf

[Gowri Sivaraman]

Hi,







Gowri-Sivaraman:~ gowri$ psql -h localhost gen3logger
psql: FATAL:  Ident authentication failed for user "gowri"





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=>

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 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

pg_hba.conf
Description: Binary data

Thanks
Gowri

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match