Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 02D9C9FB4FB for ; Sat, 2 Jun 2007 19:20:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07105-02 for ; Sat, 2 Jun 2007 19:20:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 3141C9FB484 for ; Sat, 2 Jun 2007 19:20:26 -0300 (ADT) Received: (qmail invoked by alias); 02 Jun 2007 22:20:25 -0000 Received: from i3ED6D590.versanet.de (EHLO [192.168.0.112]) [62.214.213.144] by mail.gmx.net (mp053) with SMTP; 03 Jun 2007 00:20:25 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX19vjaJK3PFvoejYbnMF01wMPyavWWp/v0/o8LeFHk YtK51fFyEahyMv Message-ID: <4661ED29.4070902@gmx.net> Date: Sun, 03 Jun 2007 00:20:25 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.4) Gecko/20070509 SeaMonkey/1.1.2 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Need a wee bit more info on PostgreSQL's SSL security options Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/12 X-Sequence-Number: 25680 Hi, I've got it so far: Server-OS: Debian 3.1 sarge PostgreSQL: Debian's binary PG 8.1.8 (still the most recent version available) Following a tutorial (actually for OpenVPN as I didn't find any for PG that goes beyond what is found in the main docu) I created a CA, server and client certificate, updated postgresql.conf and pg_hba.conf, did a restart of PG and connected from a windows box with pgAdmin. NICE :) Now as far as I see, even though I have my postgresql.crt+key in place, I still have to provide username and password, right? The server rejects my connection attempt if I move postgresql.crt+key away. Thats to be expected. Can I further check the security of the server? The aim will be to have the port open to the Internet. How can I check that PG accepts only keys produced by my CA? What would be the correct "Common Name" of a client? I read that the client can maintain a file root.crt to check the identity of the db-server. Is this the root.crt that sits in PG's data-directory or is it the server.crt ? In the documentation there is a certificate-revocation-list-file mentioned. I suspect this is to revoke a formerly granted key that got lost or is owned by a person who shouldn't be allowed to access the dbms anymore. How is this CRL file set up? Is there a documentation, that covers those matters more deeply than chapter 16.8 and 20.1 of PG's main documentation? Especially the whole client-side topic is rather thin for a newbie. Regards Andreas