Re: Online Backups PostGre (rsync for Windows)

From: "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz>
To: <pierce(at)hogranch(dot)com>, <adamruth(at)mac(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Online Backups PostGre (rsync for Windows)
Date: 2009-05-03 20:33:18
Message-ID: 49FEA84E0200007B0001AC7B@gwia1.ham.niwa.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

There are a few rsync on Windows options, just google rsync windows.... One we've found works well is DeltaCopy, which may meet your requirements.

Cheers,
Brent Wood

Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Adam Ruth <adamruth(at)mac(dot)com> 05/02/09 1:01 PM >>>
Cygwin comes with rsync on Windows.

On 02/05/2009, at 4:06 AM, John R Pierce wrote:

> Joshua D. Drake wrote:
>> Well that's just it. Out of the box it doesn't actually work.
>> PostgreSQL
>> only gives you the facilities to roll your own PITR solution. You can
>> look at PITR Tools:
>>
>> https://projects.commandprompt.com/public/pitrtools
>>
>> It doesn't quite work on Windows due to lack of rsync and signaling
>> differences but could give you an idea of how to move forward with
>> your
>> own implementation.
>>
>
> Quite possibly 'robocopy' from Microsoft somewhere (doesn't come
> with windows, but was part of an admin kit or something) would be a
> workable replacement for the rsync part.
>
>
>
> --
> 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

--
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

NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.

Browse pgsql-general by date

  From Date Subject
Next Message Adam Ruth 2009-05-03 22:17:48 Re: windows service
Previous Message Adrian Klaver 2009-05-03 20:14:33 Re: could not bind IPv4 socket