Postgres - Postgres: “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections"Article Number: 000032874 | Last Modified: 2019/01/17
If you find this error in the Windows Event Application Logs:
“psql: FATAL: remaining connection slots are reserved for non-replication superuser connections"
Then you may suffer of some connection trouble to the database.
The symptoms can be:
- Unable to connect to the web interface
- Unable for one of the service to connect to its database
This determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). This parameter can only be set at server start.
When running a standby server, you must set this parameter to the same or higher value than on the master server. Otherwise, queries will not be allowed in the standby server.
To do that stop every services (Qlik Sense or NPrinting) and go to the postgres configuration folder
- Default for NPrinting is C:\Program Files\NPrintingServer\data\
- Default for Qlik Sense is C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.x\
Search for the string "max_connection" and increase it for example from 100 to 200. This value could higher depend on the number of nodes, i.e. 6 nodes I would change from 100 to 700
Finally save the file, restart the services and check if the problem disappeared.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.