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?