Re: JDBC connection to postgres via SSL

On Fri, 25 Jun 2004, Mark Borins wrote:

> I have been able to connect via ssl to the database from a client using
> pgAdmin III without any problem.
>
> However, from the same client my JDBC application cannot connect to the
> postgres server over SSL.

The libpq client doesn't need the client to recognize the server cert,
Java's default ssl connections do.  See the following message on how to
import the cert into your java keystore:

http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php

Kris Jurka