| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vianen, Jeroen van | 2001-09-27 14:05:22 | Fix for broken JDBC's getColumn() (take 2) |
| Previous Message | Pete Jewell | 2001-09-27 10:28:07 | Re: blobs in a client/server environment |