On 14/06/17, Martin Goodson (kaemaril(at)googlemail(dot)com) wrote:
> The new master's repmgr promote script will execute commands to pause
> pgbouncer, reconfigure pgbouncer to point to the new database address, and
> then resume.
You could just move the service ip address at the new postgresql master
to which the pgbouncer instances on each app server could reconnect.
I assume, with reference to https://github.com/2ndQuadrant/repmgr, that
you could use repmgrd to trigger a script to do just that at
"switchover", possibly something you would need to monitor the
"repl_events" table to achieve.
Rory