Error "Remaining Connection Slots Are Reserved for Non-replication Superuser Connections" During New Database Connection

When trying to set up a new database connection, errors messages such as SSH-PRIVX[1584]: HOST-STORE [ERROR] pq: remaining connection slots are reserved for non-replication superuser connections are shown.

This indicates that PrivX failed to connect to the PostgreSQL database due to the exhaustion of available connection slots. PostgreSQL server has most likely reached its maximum connection limit.

Potential Solution

To resolve this issue, increase the number of allowed connections in your PostgreSQL database configuration.

After the modification, it may be needed to restart the database service (e.g., sudo systemctl restart postgresql).

Was this page helpful?