Re: Incremental backup with RSYNC or something?

From: Benjamin Henrion <bh(at)udev(dot)org>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Alex Thurlow <alex-reports(at)blastro(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Incremental backup with RSYNC or something?
Date: 2011-11-24 15:53:43
Message-ID: CANjd3nf0DYFQGvPtcXZUyK0-NZoSp-rHAbq8PjSDCXg8-e-qfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Benjamin Henrion <bhenrion at ffii.org>
FFII Brussels - +32-484-566109 - +32-2-4148403
"In July 2005, after several failed attempts to legalise software
patents in Europe, the patent establishment changed its strategy.
Instead of explicitly seeking to sanction the patentability of
software, they are now seeking to create a central European patent
court, which would establish and enforce patentability rules in their
favor, without any possibility of correction by competing courts or
democratically elected legislators."

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-24 16:02:39 Re: General performance/load issue
Previous Message Phoenix Kiula 2011-11-24 15:49:36 Re: Incremental backup with RSYNC or something?