I like being emailed when my job runs. It tells me how big the backup is and whether it passed or failed. I use
cruisecontroland ant on a regular basis so it was a natural choice. The most time consuming part was learning how to
usepg_dump.
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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