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
>