Although somewhat academic, since pgboucer doesn’t support it (and might not ever), have a look at this ticket which, if it was ever supported, would give you what you needed:
https://github.com/pgbouncer/pgbouncer/issues/75 <https://github.com/pgbouncer/pgbouncer/issues/75> > On Mar 31, 2016, at 15:47, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > >> If they are going to keep the client connections open, they would need to >> run pgbouncer in statement or transaction mode. > > As I understand, in pgbouncer you cannot have connections that serve > different users. If each individual requires its own database-level > user, pgbouncer would not help at all. > > I would look seriously into getting rid of the always-open requirement > for connections. — Chris Cogdon
