[Pacemaker] Postgresql streaming replication failover - RA needed

Florian Haas florian at hastexo.com
Wed Nov 16 05:48:44 EST 2011

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:


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.


Need help with High Availability?

More information about the Pacemaker mailing list