I currently have about 12 services connecting to my database. After running smoothly for a while, I began getting “too many client connection” errors, so I installed PgBouncer. It fixed the overload issue, but now I’m seeing a new error:

error: select * from information_schema.tables where table_name = $1 and table_schema = current_schema() - query_wait_timeout

From what I’ve learned, this happens when too many concurrent clients are waiting for connections and PgBouncer exceeds its query_wait_timeout limit.

I was advised to update my pgbouncer.ini with these settings:

pool_mode = transaction
query_timeout = 60
query_wait_timeout = 60
server_idle_timeout = 30

However, I’m not sure where to find the pgbouncer.ini file in my Railway project.

Since I plan to scale to over 100 services in the future, I’d like to know how to structure my setup to prevent this issue now and as the project grows.