Re: Online Backups PostGre

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Online Backups PostGre
Date: 2009-05-01 18:26:06
Message-ID: dcc563d10905011126y3dd52b33jb2d5ee2ff8e7bfb6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 1, 2009 at 12:06 PM, John R Pierce <pierce(at)hogranch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-05-01 18:32:00 Re: Online Backups PostGre
Previous Message John R Pierce 2009-05-01 18:06:42 Re: Online Backups PostGre