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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
