[pgpool-general: 8707] Postgres 14 / Patroni 3.01 / PGPool 4.3.3..."play nice" together settings

Dave Sisk dave.sisk at bullhorn.com
Sat Apr 1 07:33:50 JST 2023


We want to examine using PGPool as an intelligent proxy only, while letting
Patronic orchestrate failover/switcher and rewind/recovery.

Obviously, our failover_command and other similar settings should just be
blank.  What other settings should I make to allow PGPool to recognize that
the primary might have changed when PGPool is not executing that change?

We've tried setting backend_flag0/1/2 = 'DISALLOW_TO_FAILOVER', but PGPool
did not recognize the change in primary.

Would you be kind enough to advise?

Thank you in advance,

-- 

*Dave Sisk*

*Data Architect*


T:

-- 

 <https://www.linkedin.com/company/bullhorn> 
<https://twitter.com/Bullhorn> <https://www.youtube.com/@BULLHORNTV>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230331/30de7423/attachment.htm>


More information about the pgpool-general mailing list