In this talk, I'll go through the process we've developed to leverage PgBouncer for seamless failovers. I've used this approach to perform major version upgrades and resharding with minimal downtime. We'll walk through the tooling and strategies to make this possible, including configuration management, failover orchestration and monitoring. We’ll discuss the trade-offs and considerations of using PgBouncer in this context, such as performance implications, complexity in setup, and potential pitfalls. By the end of this session, you’ll have a comprehensive understanding of how to implement PgBouncer for no-downtime failovers.