Re: Patroni vs pgpool II

> Can someone please suggest what is one (Patroni vs PGPool II) is best
> for achieving HA/Auto failover, Load balancing for DB servers. Along
> with this, can you please share the company/client names using these
> tools for large PG databases?

Having used pgpool in multiple production deployments I swore to never
use it again, ever.

The first reason is that you need a doctorate degree to try to
understand how it actually works, what the pcp commands do in each
scenario and how to correctly write the failover scripts.

It is basically a daemon glued together with scripts for which you are
entirely responsible for. Any small mistake in failover scripts and
cluster enters  a broken state.

Even once you have it set up as it should, yes, it will fail over
correctly but it won't autoheal without manual intervention.

You also often end up in weird situation when backends are up, pgpool
reports down and similar scenarios and then you need to run the precise
sequence of pcp commands to recover

or destroy your whole cluster in the process if you mistype.

I haven't used patroni yet but it surely can't be worse.

Best regards, cen