X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8F0413A685C for ; Mon, 13 Dec 2004 03:36:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41265-03 for ; Mon, 13 Dec 2004 03:36:15 +0000 (GMT) Received: from pagoda.mtholyoke.edu (pagoda.mtholyoke.edu [138.110.30.68]) by svr1.postgresql.org (Postfix) with ESMTP id 2A5A93A6801 for ; Mon, 13 Dec 2004 03:36:18 +0000 (GMT) Received: from pagoda.mtholyoke.edu (rpeterso@pagoda [127.0.0.1]) by pagoda.mtholyoke.edu (8.12.11/8.12.11/Debian-5) with ESMTP id iBD3aILP022129 for ; Sun, 12 Dec 2004 22:36:18 -0500 Received: (from rpeterso@localhost) by pagoda.mtholyoke.edu (8.12.11/8.12.11/Debian-5) id iBD3aIAt022126 for pgsql-admin@postgresql.org; Sun, 12 Dec 2004 22:36:18 -0500 From: Ron Peterson Date: Sun, 12 Dec 2004 22:36:18 -0500 To: pgsql-admin@postgresql.org Subject: Re: fallback authentication Message-ID: <20041213033618.GA22117@mtholyoke.edu> Mail-Followup-To: pgsql-admin@postgresql.org References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> <20041211195107.GD2668@wolff.to> <20041212035555.GA17165@mtholyoke.edu> <20041212054308.GA28684@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041212054308.GA28684@wolff.to> Organization: Mount Holyoke College X-Operating-System: Debian GNU/Linux User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/108 X-Sequence-Number: 15694 On Sat, Dec 11, 2004 at 11:43:08PM -0600, Bruno Wolff III wrote: > On Sat, Dec 11, 2004 at 22:55:55 -0500, > Ron Peterson wrote: > > > > I have: > > > > host all all 127.0.0.1 255.255.255.255 md5 > > host all all 127.0.0.1 255.255.255.255 pam postgresql > > host all all 0.0.0.0 0.0.0.0 reject > > > > I've also tried reversing the first two lines. Either strategy > > individually works, but I'd like lookups which don't work locally to try > > pam (or vice-versa). What am I missing? > > You can't use 'all' for the username specification. You need to explicitly > list out the usernames in the first host line. (Which should be the md5 > line.) Thanks. Exactly what I was hoping for. -- Ron Peterson Network & Systems Manager Mount Holyoke College http://www.mtholyoke.edu/~rpeterso