On Wed, Dec 14, 2011 at 1:15 PM, Andy Colson <[email protected]> wrote: > Yep, you simply cron a pg_dump. (dumpall if you want users/roles and all > databases). No locking needed.
So how would one put this in cron if I wanted to run this everyday? 0 * * * * /usr/bin/pg_dumpall > pg_dumpall.$DATE.sql Will that work above assuming I wanted to run this every day at that specific time? I'm just guessing since I've never created a Crontab or messed with PG backups. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
