Thread: Ident authentication failed for user "dsivam"

Hi-

I've run into a problem using Postgres 8.1 that has me stumped:

I'm logged on as user 'postgres' and I can connect using the following
command:

    bash$>psql

However when I specify the host:

    bash$>psql -h localhost

or

    bash$>psql -h hostname.domain.com

I get the following error:

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


I have the listen_address parameter set to "*" in postgresql.conf.

Below are the permissions in my pg_hba.conf:

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

Any Ideas?

Thanks...

On Tue, Nov 28, 2006 at 03:40:09PM -0800, dsivam@gmail.com wrote:
> Hi-
>
> I've run into a problem using Postgres 8.1 that has me stumped:
>
> I'm logged on as user 'postgres' and I can connect using the following
> command:
>
>     bash$>psql
>
> However when I specify the host:
>
>     bash$>psql -h localhost

<snip>

Maybe you're not running an ident daemon?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.