Re: Cannot connect to Database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot connect to Database
Дата
Msg-id 9230.1107889433@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cannot connect to Database  (bernd@kalwar.net)
Список pgsql-general
bernd@kalwar.net writes:
> everytime I try to connect to my Database with a Java-Applikation, I
> recieve only the following Exception:

> org.postgresql.util.PSQLException: A connection error has occurred:
> org.postgresql.util.PSQLException: FATAL: kein pg_hba.conf-Eintrag f�r
> Host �127.0.0.1�, Benutzer �postgres�, Datenbank �test�, SSL aus

> I get the same error-message with other applications, e.g. pgaccess, too.

> My pg_hba.conf looks like:

> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
> METHOD

> host    all         all         127.0.0.1         255.255.255.255   trust

It is simply not possible that you get that error message with that
pg_hba.conf.  One way or another, the postmaster you are talking to is
using some other pg_hba.conf than you think it is.  Maybe you are
connecting to a different postmaster, or maybe you are editing the wrong
copy of pg_hba.conf (we've seen several people make the latter mistake
--- the relevant one is the one in the postmaster's data directory).

Or you forgot to SIGHUP the postmaster after editing the file, though
you say you did that.

            regards, tom lane

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

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: Cannot connect to Database
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Cannot connect to Database