Tony Caduto wrote:
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.
Slony or Replicator will handle that but keep in mind they are both Async.
Or would PGCluster be a better option?
Thanks,
Tony
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
