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

Re: Re. conection error

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Russ McBride" <Russ(at)psyex(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Re. conection error
Date: 2001-09-27 13:26:04
Message-ID: NEBBLAAHGLEEPCGOBHDGAEHBDLAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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


In response to

pgsql-jdbc by date

Next:From: Vianen, Jeroen vanDate: 2001-09-27 14:05:22
Subject: Fix for broken JDBC's getColumn() (take 2)
Previous:From: Pete JewellDate: 2001-09-27 10:28:07
Subject: Re: blobs in a client/server environment

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