Improving Stability for 32-bit Linux Private Agents

Introduction

Version 10.15 or lower 32-bit Linux Private Agents, or those upgraded from one these versions, may have stability issues due to a default setting in the postgresql.conf settings. Beginning with version 10.16 32-bit Linux Private Agents, the default postgresql.conf settings for max_connections is set to 400. Earlier versions use a default setting of 100.

The default of 400 max_connections applies only to 10.16 or higher Private Agents installed fresh. Upgrading an existing Private Agent to version 10.16 or higher does not change the setting. This page describes how to change the max_connections setting so it matches the new default.

Changing the max_connections Setting

As Private Agents upgraded from a prior version retain their existing postgresql.conf settings, if you have existing Private Agents installed, we recommend editing the postgresql.conf file of each Private Agent in an Agent Group using this procedure:

1. Find the postresql.conf file, located in the /opt/jitterbit/DataInterchange/psql directory.
2. Make a backup copy of the postresql.conf file and save it to another location. 
3. Open the postgresql.conf file in a text editor.

4. Find the max_connections setting in the Connection Settings section:

   # - 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 = 5432							# (change requires restart)
   max_connections = 100				# (change requires restart)
   #superuser_reserved_connections = 3	# (change requires restart)
   #unix_socket_directories = ''		# comma-separated list of directories

5. Change this setting to max_connections = 400.
6. Save your changes and restart each agent using the instructions at Installing a Jitterbit Harmony Linux Agent.