Hi Attila, On 2011-11-16 10:27, Attila Megyeri wrote: > Hi All, > > > > We have a two-node postgresql 9.1 system configured using streaming > replicaiton(active/active with a read-only slave). > > We want to automate the failover process and I couldn’t really find a > resource agent that could do the job.
That is correct; the pgsql resource agent (unlike its mysql counterpart) does not support streaming replication. We've had a contributor submit a patch at one point, but it was somewhat ill-conceived and thus did not make it into the upstream repo. The relevant thread is here: http://lists.linux-ha.org/pipermail/linux-ha-dev/2011-February/018195.html Would you feel comfortable modifying the pgsql resource agent to support replication? If so, we could revisit this issue and potentially add streaming replication support to pgsql. Cheers, Florian -- Need help with High Availability? http://www.hastexo.com/now _______________________________________________ Pacemaker mailing list: Pacemaker@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
