Postgres Pro
Downloads
Home   >   mailing lists

Re: Re. conection error - Mailing list pgsql-jdbc

From Nick Fankhauser
Subject Re: Re. conection error
Date
Msg-id NEBBLAAHGLEEPCGOBHDGAEHBDLAA.nickf@ontko.com
Whole thread Raw
In response to Re. conection error  (Russ McBride <Russ@psyex.com>)
List pgsql-jdbc
Tree view 
Hi Russ-

> The first line in my pg_hba.conf file is:
>
> local      all                                trust

I don't think this line authorizes TCP/IP socket connections, but rather,
only Unix sockets. Since JDBC uses TCP/IP even if you are on the same
machine, you'll need a similar auth record starting with "host" for
127.0.0.1 (locahost) like the one below, or using trust as the method if you
prefer.

> host         all         127.0.0.1     255.0.0.0           ident sameuser

check out this page for a better explanation:

http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA.
CONF


Regards,

-Nick

pgsql-jdbc by date:

Previous
From: Pete Jewell
Date:
Subject: Re: blobs in a client/server environment
Next
From: "Vianen, Jeroen van"
Date:
Subject: Fix for broken JDBC's getColumn() (take 2)