[Pacemaker] Postgresql streaming replication failover - RAneeded

[Attila Megyeri]

Hi Brett,

I would be very interested to see your solution. So far I had no luck with Takatoshi's RA :(

Regards,
Attila

-----Original Message-----
From: Buckingham, Brett [mailto:BBuckingham at BroadViewNet.com] 
Sent: 2011. november 17. 18:40
To: The Pacemaker cluster resource manager
Subject: Re: [Pacemaker] Postgresql streaming replication failover - RAneeded

> Well I'm not sure I would be able to do that change. Failover is
relatively easy to do but I really have no idea how to do the failback part.

>And that's exactly the reason why I haven't implemented it yet. With
the current way how replication is done in PostgreSQL there is no easy way to switch between roles, or at least I don't know about a such way.
Implementing just fail-over functionality by creating a trigger file on a slave server in the case of failure on master side doesn't create a full master-slave implementation in my opinion.

We have created just such a multi-state RA, which incorporates a design to manage failover, failback, and fallback (regular backups).  Please give us a few days - a member of my team is removing any product-specifics from it, and we'll post it shortly.

Brett


_______________________________________________
Pacemaker mailing list: Pacemaker at oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker