Confusion about ident sameuser

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "PGSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Confusion about ident sameuser
Date: 2008-07-03 01:55:03
Message-ID: 65937bea0807021855k35a920bci89656237ad592b83@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am confused with the 'ident sameuser' authentication. Here's my
setup:

[postgres(at)db2 ~]$ grep -v "^#" <data_dir>/pg_hba.conf
local all all ident sameuser
host all all 127.0.0.1/32 ident sameuser
host all all 10.0.0.0/8 password

[postgres(at)db2 ~]$ pg_ctl -D <data_dir> reload

[postgres(at)db2 ~]$ psql -h 10.10.0.27 -p 6543 -d postgres -U postgres
Password for user postgres:

[postgres(at)db2 ~]$ psql -p 6543 -d postgres -U postgres
Welcome to psql 8.1.11, the PostgreSQL interactive terminal.

[postgres(at)db2 ~]$ psql -h localhost -p 6543 -d postgres -U postgres
psql: FATAL: Ident authentication failed for user "postgres"

As you can see, if I use the machine's interface or unix sockets, it either
asks for password or lets me in. But when I use localhost, it correctly uses
127.0.... line for authentication, but does not let me in!!!

Is this not supposed to work? Could it be because I might not be having an
ident server running on my box? How do I determine if I have an ident server
running?

Thanks in advance,

--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2008-07-03 02:32:09 Re: Confusion about ident sameuser
Previous Message Klint Gore 2008-07-03 01:20:12 Re: pg_dump - lost synchronization with server: got message type "d", length 6036499