[ClusterLabs] Resource Agents: pgsql vs. pgsqlms

[Ede Wolf]

Hello,

we are about to set up a postgresql 15 ha solution and since we already
have some experience with pacemaker, this seems the obvious route to go
first. 

What however is somewhat confusing are the available resource agents. 
By default the pgsql agent is shipped, at least with debian and
SLES, that however has a copyright notice dating back to 2012.

Now, when trying to research postgres and pacemaker, most articles do
talk about PAF, or the pgsqlms resource. 

I have so far not been able to find the differences between both, and
in case PAF is, for one reason or the other, the better or more up
to date solution, why is it not shipped by default? At least not with
debian or SLES15?

Since postgres ha is rather new to us and me having been lucky not
having had to deal with perl so far, just reading the agents
themselves does not really shed that much light on this issue.  

So in case there is some documentation on comparing these two, or some
experience, that would be really helpful

Thanks

Ede