Re:Why we built yet another Postgres connection pooler
by SahAssar on Tuesday July 07, 2026 @07:41PM
(#48825520)
> But I don’t think I would want to create a real database user for every version of the app.
Why not? Database users are (usually) not expensive, and with groups you can give access to a group you just add the user to.
Adding this logic to the connection pooler seems more complicated.
Re:Why we built yet another Postgres connection pooler
by drdexebtjl on Tuesday July 07, 2026 @09:02PM
(#48826161)
Because it means connecting to the database to provision a new user on every deploy.
Also because it doesn’t really concern the database, it concerns the pooler.
Connection poolers already maintain multiple pools, it would not be complicated at all.
Every new version of your app has the potential to change behavior in a way that would affect the previous version if the connection was recycled during a progressive rollout.
But I don’t think I would want to create a real database user for every version of the app.
I suppose the connection pooler could map versioned users to the same real user, and use separate pools, but a dedicated UA field is probably better.