Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)

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-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Thursday, February 24, 2011 10:22 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general