Increase MAX CONNECTIONS for Postgres
Is there any way to increase max connections? I'm already using PgBouncer but we are running extensive database operations and I just want to stay in the green and make sure I can up my limits. 100 may not be enough on scale for us
9 Replies
Project ID:
N/AN/A
if you're using the bitnami pgbouncer image, or my template - https://railway.app/new/template/OpUzwe
you should be able to set / change the
PGBOUNCER_MAX_CLIENT_CONN from the default value of 120 to a higher valueI'll try it and let you know
Hey I'm using PGBouncer and everything works - however, I still need to increase the throughput. On the pro plan with the ram provided I can have up to 2K connections.
Is there any way I can change the conf file of postgres on railway?
@Brody
you could provide your own postgres image with a modified config file built into the image
but are these settings not something you can configure through making queries on the database?
or even by setting additional run flags via the start command?
That did the trick 👍
awsome, mind telling me what your chosen solution was?
altered max_connections and shared_buffers via sql statement
gotcha, thanks!