Re: Online Backups PostGre - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Online Backups PostGre
Date
Msg-id dcc563d10905011126y3dd52b33jb2d5ee2ff8e7bfb6@mail.gmail.com
Whole thread Raw
In response to Re: Online Backups PostGre  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Fri, May 1, 2009 at 12:06 PM, John R Pierce <pierce@hogranch.com> 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.

There is an rsync for windows, called delta copy:

http://www.aboutmyip.com/AboutMyXApp/DeltaCopy.jsp

pgsql-general by date:

Previous
From: "Chris Spotts"
Date:
Subject: Re: Handling large number of OR/IN conditions
Next
From: Johan Nel
Date:
Subject: Re: Possible to prevent transaction abort?