On Thu, Nov 24, 2011 at 11:53 PM, Benjamin Henrion <bh@xxxxxxxx> wrote: > On Thu, Nov 24, 2011 at 4:49 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: >> On Wed, Nov 23, 2011 at 6:13 AM, Alex Thurlow <alex-reports@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
