Re: psql: FATAL: Ident authentication failed for user "postgres"

Hi Luigi,

It is Linux.  I am trying to login as postgres but as a user not in the database.  This is because I will be creating a web front end, and various users, not registered in the database, will need to access the database.  Thus, as “postgres” I can log in fine:

bash-3.1$ psql kermit -U postgres

Welcome to psql 8.1.11, 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

kermit=#

But as myself, I can’t.

/home/djoo[8:25am]$ %psql kermit -U postgres

psql: FATAL:  Ident authentication failed for user "postgres"

This is pretty much the same setup I had with another company, so I am confused why I can’t access.  Is there another file that I need to alter besides the pg_hba.conf file? 

Thanks for your help,

Dan

hi,

what's your machine configuration? Linux, Mac Os?
if you are using mac, maybe you have a problem with identd.

what user are you trying to logon?

comand: psql -U <user-name> -d <database-name>
[]'s

--
Luigi Castro Cardeles