Skip site navigation (1) Skip section navigation (2)

Re: connection error

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Russ McBride" <Russ(at)psyex(dot)com>, "pgsql-jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: connection error
Date: 2001-09-26 21:40:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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           ident sameuser
host         all  trust

The first lines allow a connection on the same machine.

The last line allows a connection from the IP address
without any authentication. For details, search for pg_hba in the
interactive docs.


Nick Fankhauser

nickf(at)doxpop(dot)com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop  - Court records at your fingertips -


> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Russ McBride
> Sent: Wednesday, September 26, 2001 4:21 PM
> To: pgsql-jdbc(at)postgresql(dot)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 user: postgres
> database: testdb
> best,
> Russ
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

pgsql-jdbc by date

Next:From: Matt FairDate: 2001-09-26 21:52:40
Subject: blobs in a client/server environment
Previous:From: Nick FankhauserDate: 2001-09-26 21:29:57
Subject: Re: sequences in JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group