On Wed, Dec 14, 2011 at 1:15 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
