Re: fallback authentication - Mailing list pgsql-admin

From Dmitry Morozovsky
Subject Re: fallback authentication
Date
Msg-id 20041212210744.C63476@woozle.rinet.ru
Whole thread Raw
In response to Re: fallback authentication  (Ron Peterson <rpeterso@mtholyoke.edu>)
List pgsql-admin
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 ***
------------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: fallback authentication
Next
From: Paulo Jobim
Date:
Subject: HELP database files are incompatible with server