Hey all, new postgres user here. We are trying to setup/research an HA/Replicated solution with Postrgresql between a datacenter in LA and a d.c. in NY. We have a private LAN link between the two D.C.'s with a max round-trip of 150ms. We will have a web server at each d.c. (among other servers) that will write/read to/from the local LAN DB. On writes, that data should be xmited to the other data center so that if, for whatever reason, my website request was sent to LA instead of NY, all my session information etc will still exist. I was looking into PGCluster 1.7rc5 but their website states: "...running one Cluster DB node in a different geographical location is not what PGCluster was built for..." Does anyone have an idea? We cannot possibly be the only company needing to do this. Thanks, Matthew ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
