[MacPorts] #60662: psql: FATAL: remaining connection slots are reserved for non-replication superuser connections
MacPorts
noreply at macports.org
Mon Jun 15 22:27:07 UTC 2020
#60662: psql: FATAL: remaining connection slots are reserved for non-replication
superuser connections
-----------------------------+---------------------
Reporter: ryandesign | Owner: admin@…
Type: defect | Status: new
Priority: Normal | Milestone:
Component: server/hosting | Version:
Resolution: | Keywords:
Port: |
-----------------------------+---------------------
Comment (by neverpanic):
I have the feeling that trac got more responsive since that change, so
personally I'd do a bit of everything:
- reduce the number of gunicorn workers
- increase the number of PostgreSQL connections
- reduce the number of requests a single gunicorn worker serves before
restart
@Ryan: We're very aware of the connection limit issue, since we're also
getting it for the cronjobs. In general, our current setup seems to work
better than the previous one, at least judging from the continuity of the
memory usage, so there'll be a few days of tuning to get it right
eventually.
--
Ticket URL: <https://trac.macports.org/ticket/60662#comment:2>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list