Russ-
JDBC connects using TCP/IP and this indicates that your host machine doesn't
have a line in /etc/postgresql/pg_hba.conf allowing the requested
connection. This is necessary even if you are connecting to localhost.
Here's what our pg_hba.conf looks like:
local all peer sameuser
host all 127.0.0.1 255.0.0.0 ident sameuser
host all xxx.xxx.xxx.xxx 255.255.255.255 trust
The first lines allow a connection on the same machine.
The last line allows a connection from the IP address xxx.xxx.xxx.xxx
without any authentication. For details, search for pg_hba in the
interactive docs.
-Nick
---------------------------------------------------------------------
Nick Fankhauser
Business:
nickf@doxpop.com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
nick@fankhausers.com http://www.fankhausers.com
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Russ McBride
> Sent: Wednesday, September 26, 2001 4:21 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] connection error
>
>
> Hi,
>
> I've registered by driver with the drive manager, but I can't get a
> connection. Does anyone know what this error means:
>
> No pg-hba.conf entry for host 169.254.23.69 user: postgres
> database: testdb
>
>
>
> best,
>
> Russ
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>