Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DFC5F6325E4 for ; Tue, 13 Apr 2010 14:16:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46115-06 for ; Tue, 13 Apr 2010 17:16:10 +0000 (UTC) X-Greylist: delayed 00:11:20.418159 by SQLgrey-1.7.6 Received: from pop.ncsa.uiuc.edu (pop.ncsa.uiuc.edu [141.142.2.28]) by mail.postgresql.org (Postfix) with ESMTP id 42EEC6324A1 for ; Tue, 13 Apr 2010 14:16:10 -0300 (ADT) X-Envelope-From: jgaynor@ncsa.uiuc.edu X-Envelope-To: Received: from zanamavir.ncsa.uiuc.edu (zanamavir.ncsa.uiuc.edu [141.142.2.177]) by pop.ncsa.uiuc.edu (8.11.7/8.11.7) with ESMTP id o3DH4hs20950 for ; Tue, 13 Apr 2010 12:04:43 -0500 Received: from zimbra-1.ncsa.uiuc.edu (zimbra.ncsa.uiuc.edu [141.142.2.140]) by zanamavir.ncsa.uiuc.edu (8.14.4/8.14.4) with ESMTP id o3DH4hOI020991 for ; Tue, 13 Apr 2010 12:04:44 -0500 Date: Tue, 13 Apr 2010 12:04:43 -0500 (CDT) From: Jeffrey Gaynor To: pgsql-admin@postgresql.org Message-ID: <74745749.2535.1271178283785.JavaMail.root@zimbra-1.ncsa.uiuc.edu> Subject: SSL question MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [141.142.220.163] X-Mailer: Zimbra 6.0.5_GA_2213.RHEL5_64 (ZimbraWebClient - FF3.0 (Linux)/6.0.5_GA_2213.RHEL5_64) X-Null-Tag: 49a4bba2539687970253678a62bbf747 X-NCSA-MailScanner-Information: Please contact help@ncsa.uiuc.edu for more information, rimantadine.ncsa.uiuc.edu X-NCSA-MailScanner-ID: o3DH4hOI020991 X-NCSA-MailScanner: Found to be clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201004/276 X-Sequence-Number: 34370 I am trying to get SSL to to work with Postgres 8.1 under CentOS 5. The situation is that I have a key and cert I must use (so no self-signing) and attempting to access the database yields the message that no client cert was found in the ~/.postgresql directory. It is my understanding that I do not need a client cert, correct? I tried to fix this by setting the option "clientcert=0" in my pg_hda.conf file. Q: How to I make it so that no client cert is required? I'm a bit of a newbie with Postgres, so any and all information is happily received. Thanks!