[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:                  |
-----------------------------+---------------------
Changes (by raimue):

 * cc: neverpanic (added)


Comment:

 The portindex data is definitely [https://github.com/macports/mpbot-
 github/blob/master/pr/db/dbutil.go used by prbot] to map email addresses
 to github maintainers and for the openmaintainer/nomaintainer labels to
 pull requests on GitHub.

 With the recent upgrade, we changed the deployment of Trac to use gunicorn
 instead of mod_wsgi in apache2. That has a different worker/threading
 model. It appears that we have more open database connections now than we
 had previously. This error was also seen on some HTTP requests for Trac.

 @neverpanic, sounds like we need to increase the maximum number of DB
 connections (as we discussed privately earlier) or should we reduce the
 number of gunicorn workers?

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