[KLUG Members] Postgresql + $HOME/.pgpass

[Bruce Smith]

> dabatase:~# /usr/bin/pg_dumpall -vc -U ke4rit > 
> /work/postgres/postgresql.dump
> pg_dumpall: could not connect to database "template1": FATAL:  IDENT 
> authentication failed for user "ke4rit"

Switch to a valid user in root's crontab.  This works for me:

  su -l postgres -c "/usr/bin/pg_dumpall > backups/dumpall 2> stderr" < /dev/null

 - BS