I have two Postgresql 8.1 servers each one is in a DMZ and each one has a apache server running on it. What I want to do is have real time 2 way replication between the two databases so I can use DNS fail over, i.e when the primary goes down the secondary would take over. Then when the primary comes backup it should get all the changes that happened to the secondary while it was down.
Or would PGCluster be a better option? Thanks, Tony
