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.
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
barai(at)cs(dot)ucr(dot)edu
http://www.benjaminarai.com <http://www.benjaminarai.com/>