X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A2A7F9DD717 for ; Fri, 13 Jan 2006 17:15:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91641-05 for ; Fri, 13 Jan 2006 17:15:39 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E137A9DD742 for ; Fri, 13 Jan 2006 17:15:35 -0400 (AST) Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by svr4.postgresql.org (Postfix) with ESMTP id 50AF55AF092 for ; Fri, 13 Jan 2006 21:15:37 +0000 (GMT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:34253 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1ExWGg-0001pE-8O for pgsql-admin@postgresql.org; Fri, 13 Jan 2006 16:15:30 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 87C76406B; Fri, 13 Jan 2006 16:15:29 -0500 (EST) Date: Fri, 13 Jan 2006 16:15:29 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: PKI/SSL Client/Server Certificate Authentication Message-ID: <20060113211529.GC10098@phlogiston.dyndns.org> References: <20060113095615.S38232@arbitor.digitalfreaks.org> <25602.1137168524@sss.pgh.pa.us> <20060113114049.D38232@arbitor.digitalfreaks.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060113114049.D38232@arbitor.digitalfreaks.org> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.064 required=5 tests=[AWL=0.064] X-Spam-Score: 0.064 X-Spam-Level: X-Archive-Number: 200601/166 X-Sequence-Number: 20254 On Fri, Jan 13, 2006 at 12:19:38PM -0500, Brian A. Seklecki wrote: > In short, it's a deterrent to hackers and a convenience to admins. But we Not just that. Unless something big has changed when I wasn't looking, the jdbc driver can't use the .pgpass mechanism yet; but it _can_ use SSL, except that it doesn't have the ability to validate via certs. So there'd be another potential use case for this. I briefly toyed with trying to find someone to implement cert-based authentication, but found I had other things more pressing (so the TODO fell off the end of my list). A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin