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 E78A93A66BF for ; Sun, 12 Dec 2004 18:12:08 +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 07205-05 for ; Sun, 12 Dec 2004 18:12:02 +0000 (GMT) Received: from woozle.rinet.ru (woozle.rinet.ru [195.54.192.68]) by svr1.postgresql.org (Postfix) with ESMTP id D29993A66AD for ; Sun, 12 Dec 2004 18:12:01 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by woozle.rinet.ru (8.13.1/8.13.1) with ESMTP id iBCIBiZw069586; Sun, 12 Dec 2004 21:11:44 +0300 (MSK) (envelope-from marck@rinet.ru) Date: Sun, 12 Dec 2004 21:11:44 +0300 (MSK) From: Dmitry Morozovsky To: Ron Peterson Cc: pgsql-admin@postgresql.org Subject: Re: fallback authentication In-Reply-To: <20041212035555.GA17165@mtholyoke.edu> Message-ID: <20041212210744.C63476@woozle.rinet.ru> References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> <20041211195107.GD2668@wolff.to> <20041212035555.GA17165@mtholyoke.edu> X-NCC-RegID: ru.rinet MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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/106 X-Sequence-Number: 15692 On Sat, 11 Dec 2004, Ron Peterson wrote: RP> I have: RP> RP> host all all 127.0.0.1 255.255.255.255 md5 RP> host all all 127.0.0.1 255.255.255.255 pam postgresql RP> host all all 0.0.0.0 0.0.0.0 reject This scheme would not work. However, something like the following may help: local all pgsql ident sameuser host all dba 127.0.0.1 255.255.255.255 md5 host all local 127.0.0.1 255.255.255.255 pam postgresql So you can do local maintenance like cron backups from pgsql account, and fallback login for dba user when pam or authenticating modules are not available. Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru *** ------------------------------------------------------------------------