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 70E293A6596 for ; Sun, 12 Dec 2004 05:30:43 +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 49511-03 for ; Sun, 12 Dec 2004 05:30:32 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id F2D703A6590 for ; Sun, 12 Dec 2004 05:30:32 +0000 (GMT) Received: (qmail 28874 invoked by uid 500); 12 Dec 2004 05:43:08 -0000 Date: Sat, 11 Dec 2004 23:43:08 -0600 From: Bruno Wolff III To: Ron Peterson Cc: pgsql-admin@postgresql.org Subject: Re: fallback authentication Message-ID: <20041212054308.GA28684@wolff.to> Mail-Followup-To: Ron Peterson , pgsql-admin@postgresql.org References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> <20041211195107.GD2668@wolff.to> <20041212035555.GA17165@mtholyoke.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041212035555.GA17165@mtholyoke.edu> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/105 X-Sequence-Number: 15691 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.)