Re: Problems with user-level security

At 06:19 PM 11/6/01 -0800, Nick Sayer wrote:
>On the other hand, I do a nightly pg_dumpall as part of the backups so that
>I don't have to dump the actual database working areas. For that to work, I
>need to say
>
>local all password
>
>so that my backup script will work.

I started an IDENT server on my machines and then added a rule that said if
"ident" said the user was postgres, it had access to anything.
I don't know if that's secure enough for you, but it works for us on our
production network inside our firewall.
         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona   85016-3228