Re: Cannot connect to Database - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot connect to Database
Date
Msg-id 9230.1107889433@sss.pgh.pa.us
Whole thread Raw
In response to Cannot connect to Database  (bernd@kalwar.net)
List 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 by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: Cannot connect to Database
Next
From: Scott Marlowe
Date:
Subject: Re: Cannot connect to Database