[MacPorts] #60662: psql: FATAL: remaining connection slots are reserved for non-replication superuser connections

[MacPorts]

#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):

 @Ryan: We limited the number of requests served by a single gunicorn
 worker instance to 1000 requests before a new worker is started. This
 seems to have improved the situation as evident from our monitoring:

 [[Image(https://p.dnnr.de/qOJl19wWQiaIDWnC.png)]]

 Did you see any further such issues after Tuesday 20:00 UTC?

 In any case, I've also reduced the number of gunicorn workers to 14 now,
 and changed to restarting the servers every 500 requests. Let's see
 whether this reduces the number of open connections even further without
 compromising on Trac's performance.

-- 
Ticket URL: <https://trac.macports.org/ticket/60662#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS