Confusion about ident sameuser

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Confusion about ident sameuser
Дата
Msg-id 65937bea0807021855k35a920bci89656237ad592b83@mail.gmail.com
обсуждение исходный текст
Ответы Re: Confusion about ident sameuser  ("Douglas McNaught" <doug@mcnaught.org>)
Список pgsql-general
Hi All,

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

[postgres@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@db2 ~]$ pg_ctl -D <data_dir> reload

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

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

[postgres@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[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

В списке pgsql-general по дате отправления:

Предыдущее
От: Klint Gore
Дата:
Сообщение: Re: pg_dump - lost synchronization with server: got message type "d", length 6036499
Следующее
От: "Douglas McNaught"
Дата:
Сообщение: Re: Confusion about ident sameuser