PostgreSQL Max Connections Limit
Is there any hard limit for max connections?
Solution:Jump to solution
nothing imposed by railway, at least nothing that you'd would ever realistically run into, I think postgres's own connection limit is something like 100
12 Replies
Project ID:
ed447a02-0626-4d37-a35a-c8aa82678ceb
ed447a02-0626-4d37-a35a-c8aa82678ceb
Solution
nothing imposed by railway, at least nothing that you'd would ever realistically run into, I think postgres's own connection limit is something like 100
oh okay, i tried manually updating that to 200 but it still locks at 100 and refuses more connections
will look more into that then, thanks a lot
you can definitely update it, I've done it, but maybe you want to be using pgbouncer instead?
i am currently using another pooling lib, but the issue with that is that i am using gunicorn with eventles and each worker gets its own pool, which is not working quite like i expected it to be
have you set applicable pool limits for the amount of workers you're running?
have to look into that
thanks a lot!
no problem, let me know if you have any other questions
btw did you update it yourself by using the ALTER sql command or how?
I think I did it as a flag in the start command, but from what youve told me I'll say that just increasing the limit isn't the best solution
yeah right
okay thanks 🙂