PostgreSQL error "remaining connection slots are reserved for non-replication superuser connections"

  • Document ID:7024137
  • Creation Date:24-Sep-2019
  • Modified Date:24-Sep-2019
    • Micro Focus Products:
      Filr

Environment

Filr 4.0
Large/Expandable deployment

Situation

When attempting to manage shared items (Path: Port 8443 Filr Admin Console Management > Shares), after a long delay it is observed that Filr has crashed with the utilization of the PostgreSQL database appliance being very high. In the server log, the error was:

 Remaining connection slots are reserved for non-replication superuser connections

Note: The error log can be accessed from Path: Port 9443 Appliance Console  System Services icon > Postgres > download link, or from the file system at /var/opt/novell/postgres.

Resolution

Edit the PostgreSQL configuration file /vastorage/postgres/data/postgresql.conf and increase the value for max_connections. The value for shared_buffers may also need to be increased.

Cause

Insufficient connections allocated for PostgreSQL tasks.