Re: will slony work for this ?

On Thursday 16 March 2006 14:46, Joshua D. Drake wrote:
> 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.
>

I have some doubts. If the primary fails, how will the secondary know to take
over? In slony at least, you'll have to issue a failover command (switchover
wont work on the downed primary) which means you downed primary will be in an
untrustable state. The importance of this being that there will be no way for
it to just "get all the changes"; you'll have to rebuild it. My
understanding is the same is true for replicator, but perhaps you can
elaborate on that?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL