[ADMIN] HA for high insert volume

[John Sequeira]

I'm looking for some suggestions for setting up a remote failover Postgres instance (warm spare). In my situation, the db to be failed over has a very high # of INSERTS (it does a lot of logging), and it seems like there might be too much overhead using something like usogres or one of the replication options. We expect it to grow very quickly to the point at which a full dump and load is not practical (5-15G).

Are people having luck using something like rsync in this instance? This document :
http://www.taygeta.com/ha-postgresql.html
describes using rsync, but in the case where the # of inserts is low.

Is that working for people, or is there a better way to do this?
We're willing to consider commercial solutions but would prefer OSS.

Thanks in advance,

John Sequeira


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster