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