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.