Re: Cannot connect to Database

bernd(at)kalwar(dot)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 fr
> 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