Postgresql and SSL - Mailing list pgsql-general

From Benjamin Smith
Subject Postgresql and SSL
Date
Msg-id 200709192136.04923.lists@benjamindsmith.com
Whole thread Raw
Responses Re: Postgresql and SSL  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List 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.


pgsql-general by date:

Previous
From: "Gokulakannan Somsundaram"
Date:
Subject: Planning a Postgresql based Database
Next
From: Chester
Date:
Subject: Stuck on Foreign Keys