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.
Joshua D. Drake
My initial thought involved streaming a pg_dump from main server to
the backup server every week and doing the pg_restore on the receiving
side. I initially tried using slony but it just took too long for
slony to catch up and there is no real need to do replication during
the update. Does that seem like the best option?
*Benjamin Arai*
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.benjaminarai.com <http://www.benjaminarai.com/>
**
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
