PGBouncer Template
complete
Log In
Anurag Goel
complete
PgBouncer instructions here: https://render.com/docs/databases#connection-pooling
Anurag Goel
We have a template here: https://github.com/render-oss/docker-pgbouncer. You can start using it as a Docker service now; docs and updated README coming shortly.
Anurag Goel
in progress
On its way!
d
dev
Any updates here?
V
Vitor Amaral
Any updates on this?
Anurag Goel
Merged in a post:
Allow configuring database connections
G
Guilherme Duarte
We would be great to allow customizing the number of allowed Postgres database connections.
This is especially useful for PR preview environments, where multiple service instances would need to connect to a single database, thus easily reaching the connection limit.
Anurag Goel
planned
Anurag Goel
under review
Anurag Goel
We might just include pgbouncer in our default hosted offering.
A
Aaron Ng
Anurag Goel: that would be “very lit”
B
Braden Sidoti
Anurag Goel: Are you envisioning exposing config options? We use https://github.com/awslabs/pgbouncer-rr-patch and would like that supported, if possible.
Anurag Goel
Braden Sidoti: cc Adrian Duong
Adrian Duong
Braden Sidoti: It doesn't seem this is just a configuration on pgbouncer but a patch. We probably wouldn't be supporting this out of the box. We could have a template for this though.
B
Braden Sidoti
Adrian Duong: Yes, that's correct. Our setup uses the patch and changes a bunch of the standard config that we can't do with heroku's connection pooler. If we can't do the patch, we won't have a use for the standard config, though.
Our bouncer is public facing, so unfortunately I don't think we can move it off AWS until we can open arbitrary TCP ports.