Re: Incremental backup with RSYNC or something?

On Thu, Nov 24, 2011 at 11:53 PM, Benjamin Henrion <bh(at)udev(dot)org> wrote:
> On Thu, Nov 24, 2011 at 4:49 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
>> On Wed, Nov 23, 2011 at 6:13 AM, Alex Thurlow <alex-reports(at)blastro(dot)com> wrote:
>>> On 11/22/2011 3:28 PM, Merlin Moncure wrote:
>> ......
>>> How long is this backup taking?  I have a ~100GB database that I back up
>>> with pg_dump (which compresses as it dumps if you want it to) and that only
>>> takes 35 minutes.  Granted, I have it on some fast SCSI drives in RAID 1,
>>> but even a single SATA drive should still finish in a decent amount of time.
>>
>>
>> Hi Alex, could you share what exact command you use? Mine are SCSI
>> too, in RAID 10, but the dump takes over 2-3 hours (60 GB database)
>> and the CPU consumption during this time is huge.
>
> I wrote a bunch of shell scripts tools to backup postgres 9.1 with
> rsync/ccollect (another hardlink tool), I might find the time to
> publish it on github once I find the time.

Thanks Ben. Look forward to it.

Will the script be different for version 9.0.5? Would love to have
rsync working. Even without a script, just the commands will help.