You may need to increase the maximum connections if you receive an error message similar to the following:
Failed to connect to back-end database "TranDb"
FATAL: remaining connection slots are reserved for non-replication superuser
(0) SQL Error! SQLSTATE = 53300 Native err = 210 msg = FATAL: remaining connection slots are reserved for non-replication superuser connections
(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Unable to connect to database using connection string:
Changing the max_connections Setting
This change is needed for 64-bit Windows Private Agents installed prior to the Jitterbit Harmony 10.14 release. In addition to changing the max_connections settings, change the checkpoint_timeout settings.
Make a backup copy of your postgresql.conf file and save it to another location. This file can be found in the C:\Program Files\PostgreSQL\9.x\data directory.
Open the postgresql.conf file in a text editor.
Find the max_connections setting.
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 6543 # (change requires restart)
max_connections = 100 # (change requires restart)
#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directories = '' # comma-separated list of directories