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(at)plukwa(dot)net