Re: Syncing Databases Weekly

Brad Nicholson wrote:

> Joshua D. Drake wrote:
>
>> Benjamin Arai wrote:
>>
>>> Hi,
>>>
>>> I am familiar with applications like slony for replications, I am
>>> looking for a technique for syncing a very large database every week
>>> for backup and redundancy purposes.  More specifically, I do all my
>>> writes to a main server once a week, at the end of the updates I
>>> would like to automatically copy all of the data to a second server
>>> as a live backup in case the main system ever goes down.
>>
>>
>>
>> You could use batch replication via Mammoth Replicator or PITR.
>>
> Slony's log shipping is another option.

Oh cool... I didn't know Slony could do that. Glad to hear it.

>
>