Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Navigation

    Cloudron Forum
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    SOLVED What does "FATAL: remaining connection slots are reserved for non-replication superuser connections" mean?

    Support
    postgresql
    3
    3
    143
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • luckow
      luckow last edited by girish

      Today I was informed via a Cloudron notification that the Postgres service is being terminated because of this FATAL. Restarting the service helped. But I have no clue what this means. Does anyone know anything about this Postgres error?

      Pronouns: he/him
      Primary language: German
      A big fan of Vulfpeck, Scary Pockets & Jacob Collier

      1 Reply Last reply Reply Quote 0
      • nebulon
        nebulon Staff last edited by

        I think this means that the postgres server ran out of available connection slots in the pool, possibly due to too many clients or buggy clients. Some of those slots are apparently reserved for some admin/superuser connection, I guess to still be able to do maintenance.

        Which apps do you have installed which use postgres? (I think you have to dig into the CloudronManifests to figure that)

        1 Reply Last reply Reply Quote 0
        • girish
          girish Staff last edited by

          I finally managed to get to the bottom of this. There was a bug in the postgresql addon backup logic where connections were not closed properly. This resulted in periodic backups keeping lots of connections open. This is fixed in 6.3.

          1 Reply Last reply Reply Quote 4
          • First post
            Last post