Alex -
Have you tried this RA: https://github.com/t-matsuo/resource-agents/ ?
So far it's the best candidate for an official PostgreSQL RA with streaming
replication support. However be advised that it's still under development.
It'll be very interesting to hear you opinion on it.
On Tue, Jan 1
Hello Brett,
Is it possible to get your solution now?
--
With best regards,
Alex Tkachev,
IPTV Engineer,
CTI, Moscow, Russia
>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
t: 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
> 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
