I think a user can have a crontab too. crontab -e postgres (edit user's crontab). Give that a shot. On Sun, 12 Sep 2004 16:12:38 -0500, Tim Wilson <wilson at visi.com> wrote: > 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 > -- John T. Hoffoss _______________________________________________ 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