Increase number of Postgres Clients | Railway | Page 1

dire beacon Oct 7, 2023, 8:49 PM

#

How do I increase the number of clients that can connect to my postgres database?

frosty oxideBOT Oct 7, 2023, 8:49 PM

#

Project ID: N/A

hushed wrenBOT Oct 7, 2023, 8:49 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

dire beacon Oct 7, 2023, 8:50 PM

#

https://i.mrxbox98.me/file/2023/10/chrome_dbk21tSSBv.png

bitter spruce Oct 7, 2023, 8:54 PM

#

how many connections would you say you need? the default max is 100

crude flax Oct 7, 2023, 8:56 PM

#

btw, i would recommend you to use something like pgbouncer instead of increasing the connection.

#

a pgbouncer template would be nice too 👀

bitter spruce Oct 7, 2023, 9:00 PM

#

seems plenty easy
https://hub.docker.com/r/bitnami/pgbouncer/

#

but op, if what should be done doesnt concern you, use this as the start command
docker-entrypoint.sh postgres -c max_connections=300 -c shared_buffers=80MB --port=5432

dire beacon Oct 7, 2023, 11:42 PM

#

Gotcha, I only have 5 replicas of a project that uses the db through prisma so not sure how im hitting 100 connections. Ill have to check through my code to see whats going wrong

#Increase number of Postgres Clients