pgbouncer has PAUSE comnand, which can be used for seamless restarts/failovers or similar