Search Postgresql Archives

Re: Cannot connect to Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



bernd@xxxxxxxxxx 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux