[ClusterLabs] Community adoption of PAF vs pgsql

[Jehan-Guillaume de Rorthais]

Hi,

I'm one of the PAF author, so I'm biased.

On Fri, 26 Mar 2021 14:51:28 +0000
Isaac Pittman <isaac.pittman at hitachivantara.com> wrote:

> My team has the opportunity to update our PostgreSQL resource agent to either
> PAF (https://github.com/ClusterLabs/PAF) or pgsql
> (https://github.com/ClusterLabs/resource-agents/blob/master/heartbeat/pgsql),
> and I've been charged with comparing them.

In my opinion, you should spend time to actually build some "close-to-prod"
clusters and train them. Then you'll be able to choose base on some team
experience.

Both agent have very different spirit and very different administrative tasks.

Break your cluster, make some switchover, some failover, how to failback a node
and so on.

> After searching various mailing lists and reviewing the code and
> documentation, it seems like either could suit our needs and both are
> actively maintained.
> 
> One factor that I couldn't get a sense of is community support and adoption:
> 
>   *   Does PAF or pgsql enjoy wider community support or adoption, especially
> for new projects? (I would expect many older projects to be on pgsql due to
> its longer history.)

Sadly, I have absolutely no clues...

>   *   Does either seem to be on the road to deprecation?

PAF is not on its way to deprecation, I have a pending TODO list for it.

I would bet pgsql is not on its way to deprecation either, but I can't speak
for the real authors.

Regards,