I'm testing the pgbouncer "pause" feature to minimize database downtime when a database restart is required.
For this test, I have a remote psql session connected to my database through pgbouncer. Pgbouncer SHOW CLIENTS shows my remote session as Active even with no queries running. The same client shows Idle according to pg_stat_activity. When I issue the PAUSE command, it hangs until I close my remote session. Shouldn't PAUSE work without closing my connection?