Re: Automated database backups and authentication

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