Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A37A09FB43C for ; Sun, 3 Jun 2007 20:25:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 37652-07 for ; Sun, 3 Jun 2007 20:25:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 221BE9FB265 for ; Sun, 3 Jun 2007 20:25:48 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id AD139118A18; Sun, 3 Jun 2007 19:25:47 -0400 (EDT) Date: Sun, 3 Jun 2007 19:25:47 -0400 From: Ray Stell To: Andreas Cc: pgsql-admin@postgresql.org Subject: Re: Need a wee bit more info on PostgreSQL's SSL security options Message-ID: <20070603232547.GD29909@cns.vt.edu> References: <4661ED29.4070902@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4661ED29.4070902@gmx.net> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/13 X-Sequence-Number: 25681 Read the entries listed here: http://archives.postgresql.org/pgsql-admin/2006-10/msg00103.php Everything came together for me with: http://www.postgresql.org/docs/8.1/interactive/libpq-ssl.html You might want to state your goals, because the config varies depending on what you are trying to accomplish. On Sun, Jun 03, 2007 at 12:20:25AM +0200, Andreas wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly