Tuesday, February 9, 2010

JDBC options for PostgreSQL SSL connection

Hi:

I was trying to find out which options I need to pass to the PostgreSQL JDBC driver in order to establish an SSL connection to the RDBMS. I found that the following are required:

  1. ssl=true (doh!)
  2. sslfactory=org.postgresql.ssl.NonValidatingFactory
The second one is only required if the SSL certificate used by the RDBMS is not signed by a trusted authority.

I hope someone finds this useful.

1 comment:

Javier said...

I don't want no tech details! I want to know about your cat!!!