On Sun, Sep 12, 2004 at 04:12:38PM -0500, Tim Wilson wrote: > 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? I'd do something along the lines of: su postgres -c pg_dump -- trammell at el-swifto.com 9EC7 BC6D E688 A184 9F58 FD4C 2C12 CC14 8ABA 36F5 Twin Cities Linux Users Group (TCLUG) Minneapolis/St. Paul, Minnesota _______________________________________________ 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