Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 06E859FB7CF for ; Wed, 2 May 2007 19:13:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 09149-10 for ; Wed, 2 May 2007 19:13:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.polimetrix.com (mail.polimetrix.com [209.128.109.230]) by postgresql.org (Postfix) with ESMTP id 7EB969FB4BE for ; Wed, 2 May 2007 19:13:19 -0300 (ADT) Received: from [10.1.1.201] ([10.1.1.201]) by mail.polimetrix.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.1830); Wed, 2 May 2007 15:13:12 -0700 Message-ID: <46390CF7.2040200@polimetrix.com> Date: Wed, 02 May 2007 15:13:11 -0700 From: Geoff Tolley User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.10) Gecko/20070226 CentOS/1.0.8-0.2.el4.centos SeaMonkey/1.0.8 MIME-Version: 1.0 To: Tom Lane CC: Rob Cherry , pgsql-admin@postgresql.org Subject: Re: Multiple auth types for a connection References: <1178137371.17100.6.camel@sphere.lxrb.com> <21650.1178142158@sss.pgh.pa.us> In-Reply-To: <21650.1178142158@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 02 May 2007 22:13:12.0286 (UTC) FILETIME=[12C9EFE0:01C78D07] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/30 X-Sequence-Number: 25350 Tom Lane wrote: > Rob Cherry writes: >> Does anyone know if it is possible to overload auth types like this such >> that if pam fails password would be tried? > > No, it's not, as per the Fine Manual: Provided that you don't care about the security and performance implications of SSL vs non-SSL connectivity, wouldn't it be possible to have something like: hostnossl all all 0.0.0.0/0 krb5 hostssl all all 0.0.0.0/0 md5 ... and then have sslmode set to prefer or allow on the client side? Cheers, Geoff