Re: Fully-automatic streaming replication failover when master dies?

On 1/22/2014 1:35 PM, Dmitry Koterov wrote:
>
> So does something similar and more-or-less stable exist for PostgrSQL
> too?
>

you'd need to implement that yourself using a cluster management
package, and something like repmgr to handle the transitions.

database failover is extremely tricky stuff.  you have to make very very
sure you don't get into a stoned cluster where both nodes THINK they are
master.   most well implemented failover clusters make use of hardware
'fencing' to block the presumed-dead former master from coming back
online without manual intervention.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast