Hey everyone,

I've got a bash script that runs pg_dump for all the PostgreSQL databases on
my system. Currently the script only works if it runs as the postgres user.
I'd like to have it run daily from cron, but it doesn't work because root
can't connect to the databases.

What's standard sysadmin practice in this situation?

-Tim

-- 
Tim Wilson
Twin Cities, Minnesota, USA
Educational technology guy, Linux and OS X fan, Grad. student, Daddy
mailto: wilson at visi.com   aim: tis270   public key: 0x8C0F8813


_______________________________________________
TCLUG Mailing List - Minneapolis/St. Paul, Minnesota
Help beta test TCLUG's potential new home: http://plone.mn-linux.org
Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery
tclug-list at mn-linux.org
https://mailman.real-time.com/mailman/listinfo/tclug-list