Database connection max pool reached in Qlik Sense Enterprise on Windows

[Zareh_T]

The following error is logged in the Qlik Sense central node's repository log: 

ERROR: occurred because all pooled connections were in use and max pool size was reached.
...
Error when committing remaining connection slots are reserved for non-replication superuser connections↵↓The underlying provider failed on Open.↵↓Exception of type 'Repository.Core.Exceptions.TransactionException' was thrown

This is typically logged in the System_Repository log.

Environment

Qlik Sense Enterprise on Windows 

Resolution

It may be necessary to configure the Repository PostgreSQL database to listen to additional requests from the rim nodes to allow database access to the rim nodes. See PostgreSQL: postgresql.conf and pg_hba.conf explained for details.