You can temporarily reduce query timeout to a smaller setting as part of the automated failover. The long running transactions will fail but you can minimize th

You can temporarily reduce query timeout to a smaller setting as part of the automated failover. The long running transactions will fail but you can minimize the window where you can't talk to postgres