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 249153A6447 for ; Sat, 11 Dec 2004 19:39:01 +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 27515-03 for ; Sat, 11 Dec 2004 19:38:48 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id DEFD53A6440 for ; Sat, 11 Dec 2004 19:38:35 +0000 (GMT) Received: (qmail 3159 invoked by uid 500); 11 Dec 2004 19:51:07 -0000 Date: Sat, 11 Dec 2004 13:51:07 -0600 From: Bruno Wolff III To: Ron Peterson Cc: pgsql-admin@postgresql.org Subject: Re: fallback authentication Message-ID: <20041211195107.GD2668@wolff.to> Mail-Followup-To: Ron Peterson , pgsql-admin@postgresql.org References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041211015056.GA13388@mtholyoke.edu> User-Agent: Mutt/1.5.6i 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/102 X-Sequence-Number: 15688 On Fri, Dec 10, 2004 at 20:50:56 -0500, Ron Peterson wrote: > On Fri, Dec 10, 2004 at 03:20:50PM -0500, Ron Peterson wrote: > > > Sometimes, however, I would like to create an account in PostgreSQL > > which I do not want to also maintain in LDAP. Is it possible to > > configure authentication to fall through to a different method? > > I suppose the right thing to do is either > > * don't be lazy, and update my LDAP maintainance to include the > required accounts, or > > * fall through in pam. Is there anything similar in concept to > libpam-pgsql, but which simply authenticates against PostgreSQL's > built-in authentication mechanism? You can put per user exceptions first in your pg_hba.conf file. That way these people will be handled by those rules, but other users can be authenticated using pam.