Quoting George Koras <gkoras(at)cres(dot)gr>:
> When I try to connect via JDBC to PostgreSQL I get the following error
> Error -- Something unusual has occured to cause the driver to fail.
> Please report this exception:
> java.sql.SQLException: No pg_hba.conf entry for host 220.127.116.11,
> user aaa, database bbb
> However, the only lines in pg_hba.conf that are not commented out are:
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all 18.104.22.168 255.255.255.0 trust
Hmmm, that should work...
> Isn't this strange? I tried this with both jdbc6.5-1.2.jar and
> jdbc7_0-1_2.jar from 22.214.171.124 which runs Linux and from my WinNT
> 4.0 (sp6) machine and for different databases.
> I use PostgreSQL 6.5.2 and before you ask, yes postmaster runs with the
> -i option set.
If you missed -i out you would have got "Connection Refused" not this
Exception. The postmaster is listening, but is refusing the connection for some
Can you use psql or another interface from 126.96.36.199?
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
In response to
pgsql-jdbc by date
|Next:||From: George Koras||Date: 2001-02-22 10:12:56|
|Subject: Re: No pg_hba.conf entry|
|Previous:||From: Shankar Gowda||Date: 2001-02-22 06:49:52|
|Subject: unable to find postgresql.jar|