Обсуждение: SCRIPT FOR AUTOMATIC PROMOTION FOR PGBOUNCER

2019年11月19日(火) 16:12 Peter Wainaina <petwah17@gmail.com>:
>
> I have been working for some days on a script to do auto update on pgbouncer.ini when automatic fail-over happens for
rep-mgrbut have not been able to crack it.Kindly help 

In case you aren't aware, there is a sample script available here:

    https://github.com/2ndQuadrant/repmgr/blob/master/doc/repmgrd-node-fencing.md

Regards

Ian Barwick

Another alternative to building a new config every time is to have one
configuration file per Primary and just use a symbolic link to specify
the correct one. One RELOAD later, and you're done.

-- 
Shaun M Thomas - 2ndQuadrant
PostgreSQL Training, Services and Support
shaun.thomas@2ndquadrant.com | www.2ndQuadrant.com