[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