On Wed, Dec 14, 2011 at 1:38 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote: > this'll run every hour. > >> 0 * * * * /usr/bin/pg_dumpall> pg_dumpall.$DATE.sql Thank you! > try: > > 0 4 * * * /usr/bin/pg_dumpall> pg_dumpall.$DATE.sql > > that'll run at 4am every day. When I run the command in my shell (not in Cron), I'm prompted for my login password. Should I change the permissions in pg_hba.conf and enable INHERIT grants on my user? Should I place this in who's Cron line? Postgres? Carlos? or Root? > > Watch the path's, who know's what directory is current: > > 0 4 * * * /usr/bin/pg_dumpall > /backup/pg_dumpall.$DATE.sql Yes, I always check my paths and use full paths rather than symbolic links. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
