[KLUG Members] Postgresql + $HOME/.pgpass

[Richard Zimmerman]

Hmmm... I like this idea.... Thanks for the tip...

Richard


Bruce Smith wrote:

>>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
>  
>
-- 
Richard "Goose" Zimmerman
Safety Assistant / IT Guru
K&B Transport, Inc. - Elkhart, IN
(574) 389-1986   (574) 389-8527 Fax
(800) 548-2718   (574) 850-5764 Cell