Readonly mode for PGBouncer "Session" pools needs to be handled differently.

Given how PGBouncer session pooling works, we will not be able to enable read-only mode as cleanly as we can in transaction mode.  When running in `session` mode, connections will need to be killed / resumed.