Re: Syncing Databases Weekly

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.


--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.