Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
4720 Weergaven

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
Annuleer