Re: authentication problems

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: authentication problems
Дата
Msg-id 799.1001822151@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: authentication problems  (Russ McBride <Russ@psyex.com>)
Ответы Re: authentication problems  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
Russ McBride <Russ@psyex.com> writes:
> Typing "/usr/local/pgsql/bin/psql -h localhost testdb" starts up my
> database in psql quite nicely, which seems to indicate to me that the
> pg_hba.conf is being read and the line:

> local  all                        trust
> is working as expected (I assume that this is the line that allows
> all local UNIX socket connections).

You assume wrong: "-h localhost" triggers a connection over IP, not
over UNIX sockets.  Specifically, it's going to match the pg_hba.conf
line that mentions 127.0.0.1.

At this point I think your problem is that your JDBC setup is trying
to connect to your machine by name, not by the "localhost" alias,
and this results in a connection via your current network IP address
rather than the 127.0.0.1 loopback address.  Since you have an entry
in pg_hba.conf for 127.0.0.1 and not the other address, only the
localhost address will work.

            regards, tom lane

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

Предыдущее
От: Russ McBride
Дата:
Сообщение: Re: authentication problems
Следующее
От: Stefan Huber
Дата:
Сообщение: Re: authentication problems