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.
