R
Railway•9mo ago
ZEYD

PostgreSQL Max Connections Limit

Is there any hard limit for max connections?
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
Jump to solution
12 Replies
Percy
Percy•9mo ago
Project ID: ed447a02-0626-4d37-a35a-c8aa82678ceb
ZEYD
ZEYDOP•9mo ago
ed447a02-0626-4d37-a35a-c8aa82678ceb
Solution
Brody
Brody•9mo ago
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
ZEYD
ZEYDOP•9mo ago
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
Brody
Brody•9mo ago
you can definitely update it, I've done it, but maybe you want to be using pgbouncer instead?
ZEYD
ZEYDOP•9mo ago
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
Brody
Brody•9mo ago
have you set applicable pool limits for the amount of workers you're running?
ZEYD
ZEYDOP•9mo ago
have to look into that thanks a lot!
Brody
Brody•9mo ago
no problem, let me know if you have any other questions
ZEYD
ZEYDOP•9mo ago
btw did you update it yourself by using the ALTER sql command or how?
Brody
Brody•9mo ago
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
ZEYD
ZEYDOP•9mo ago
yeah right okay thanks 🙂
Want results from more Discord servers?
Add your server