Postgresql and SSL

From: Benjamin Smith <lists(at)benjamindsmith(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql and SSL
Date: 2007-09-20 04:36:04
Message-ID: 200709192136.04923.lists@benjamindsmith.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using 8.1 RPMs for CentOS and so far, it's been great.

Now, I'm going to enable SSL. I had no trouble with the instructions on the
documentation for server-only certificates, and verified that psql (Linux)
acknowledges the SSL connection.

But I am stumped as to how to create a client certificate that's enforced!

I tried the instructions found
http://marc.info/?l=tomcat-user&m=106293430225790&w=2

and used the "ca.pem" created there as the postgres root.crt and although the
PG daemon no longer indicates that it couldn't find root.crt, it also doesn't
require a client certificate installed to access with psql.

Any pointers for somebody who is NOT an ssl guru? (like myself!)

-Ben

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2007-09-20 04:59:47 Re: Stuck on Foreign Keys
Previous Message Gokulakannan Somsundaram 2007-09-20 04:27:30 Planning a Postgresql based Database