I like being emailed when my job runs. It tells me how big the backup is and whether it passed or failed. I use cruisecontrol and ant on a regular basis so it was a natural choice. The most time consuming part was learning how to use pg_dump.
-----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, February 24, 2011 10:22 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4) On 02/24/11 7:09 PM, Adam Bruss wrote: > I'm using cruisecontrol and ant to back up our database at certain > times on certain days of the week. Cruisecontrol sends out completion > emails when it's done. I don't think pgsql has a good built in way to > schedule backups. Cruisecontrol offers supreme flexibility with > relatively little work. > wow, thats a complicated lotta stuff to do what crontab would do with a oneliner 0 6 * * 3,6 pg_dump <args to dump> (06:00 on wed,sat) or the windows task scheduler equivalent. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
