> This approach doesn’t work for LISTEN because typically a client will listen for its entire lifecycle so you can’t share connections in a pool.
But you only need one connection for LISTEN per database, total. So I'm confused why this is made out to be a big issue.