pg_hba.conf confusion

Поиск
Список
Период
Сортировка
От David M. Kaplan
Тема pg_hba.conf confusion
Дата
Msg-id 3D0EAD4F.9060305@ucdavis.edu
обсуждение исходный текст
Ответы Re: pg_hba.conf confusion  (Reinhard Max <max@suse.de>)
Re: pg_hba.conf confusion  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
Hi,

I recently experienced a weird bug with postgresql. I am running:

postgresql-7.2.1-8
postgresql-server-7.2.1-5

I was trying to connect to a database on a my machine from another
machine.  Initially, my pg_hba.conf looked like:

host       all         127.0.0.1     0.0.0.0    ident    sameuser
host    all    192.168.1.2    255.255.255.128    password

where my machine is 192.168.1.1 and the client is 192.168.1.2.
Connecting using psql -h 192.168.1.1 failed stating:

FATAL 1: IDENT authentification failed for user 'me'

Then I changed the order of the lines in my configuration file:

host    all    192.168.1.2    255.255.255.128    password
host       all         127.0.0.1     0.0.0.0    ident    sameuser

Now the connection worked without problems.  In the first case, it seems
to be trying to use IDENT authentification, even though that should only
apply to localhost.

David K.

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

Предыдущее
От: "Josh Goldberg"
Дата:
Сообщение: referential integrity through inherited tables
Следующее
От: Reinhard Max
Дата:
Сообщение: Re: pg_hba.conf confusion