Thread: SCRIPT FOR AUTOMATIC PROMOTION FOR PGBOUNCER
I have been working for some days on a script to do auto update on pgbouncer.ini when automatic fail-over happens for rep-mgr but have not been able to crack it.Kindly help
WEB developer and programmer
system analyst-crm
blogger
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