Re: Problems with user-level security

From: "Chad R(dot) Larson" <chad(at)eldocomp(dot)com>
To: Nick Sayer <nsayer(at)quack(dot)kfu(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problems with user-level security
Date: 2001-11-07 15:25:07
Message-ID: 4.2.2.20011107081953.00a7c540@smtp.eldocomp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)eldocomp(dot)com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-11-07 17:03:52 Re: Problems with user-level security
Previous Message Sean K. Sell 2001-11-07 14:56:56 Re: Problems with user-level security