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