Re: Automated database backups and authentication - Mailing list pgsql-admin

From Artur Pietruk
Subject Re: Automated database backups and authentication
Date
Msg-id 20020806213458.GF996@yoda.plukwa.net
Whole thread Raw
In response to Re: Automated database backups and authentication  (Darren McClelland <darren@zonarsystems.com>)
Responses Re: Automated database backups and authentication  ("Chad R. Larson" <clarson@eldocomp.com>)
Re: Automated database backups and authentication  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-admin
On Tue, Aug 06, 2002 at 11:39:03AM -0700, Darren McClelland wrote:
> Thanks, that's an idea. I'd always been thinking of ident as unreliable, but
> if I control the authenticating server then it's something usable. At least I
[cut]

    Well, if you want to use ident that way, than you have to trust not
only those two servers, but all hosts in their network segments - do not
forget about ARP poisoning.

    I think, that in your setup it would be better to do crypt=-auth
and:

    - use PGPASSWORD environment variable, just set it before you execute
pg_dumpall. Go and check pgsql-admin list archives - I remember that lately
PG developers stated that PGPASSWORD variable may not be available in the
next PG release - but in that case there will be other way to give password.
Also check online docs: http://www.postgresql.org/idocs/index.php?libpq-envars.html.

    OR:

    - you can try to pass password to pg_dumpall through tricks like:
    "echo mypass | pg_dumpall .... "

    Best regards,
--
--- Artur Pietruk, arturp@plukwa.net

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: Re: High Availability PostgreSQL HOWTO article
Next
From: Andrew Sullivan
Date:
Subject: Re: High Availability PostgreSQL HOWTO article