Re: fallback authentication

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 ***
------------------------------------------------------------------------