Re: 9.2 Observer node for streaming replication - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: 9.2 Observer node for streaming replication
Date
Msg-id 51E42030.3030400@commandprompt.com
Whole thread Raw
In response to 9.2 Observer node for streaming replication  (Jorge Torralba <jorge.torralba@gmail.com>)
Responses Re: 9.2 Observer node for streaming replication  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
On 7/15/2013 8:55 AM, Jorge Torralba wrote:
> I have a master and a slave running streaming replication between the
> two servers. I would like to setup some kind of third machine to play
> the role of observer node to monitor the replication and do the
> automatic fail over.  However, I can't find any documentation or
> suggestions on such an implementation. Is it possible to do with 9.2.4
> or will I need to rely on some sort of F5 load balancer to handle the
> auto failover?

Depends on your OS. We do this all the time with our HAC setups and we
don't need any kind of load balancer to pull it off.

JD



pgsql-admin by date:

Previous
From: Jorge Torralba
Date:
Subject: 9.2 Observer node for streaming replication
Next
From: Prashanth Ranjalkar
Date:
Subject: Re: 9.2.2 - semop hanging