On Wed, Dec 14, 2011 at 1:15 PM, Andy Colson <andy@squeakycode.net> 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.