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?