Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
4718 Prikazi

Hey everyone, having an issue with maxing out connections to psql:

`OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections`


I've increased max_connections to 500, which worked great for a few hours, but now it's hitting the limit again and causing issues.


I've read some guides online about clearing out idle connections, but nobody seems to have a clean cut solution, and it seems fishy that <10 users need 500+ connections.


Any suggestions on what I can do about this?


Edit: running SELECT * FROM pg_stat_activity; in psql shows only 8 connections open. I tried again a little later, and got 31 connections. Why would odoo keep reporting running out of connections?

Avatar
Opusti