This documentation is valid only for Console 1.x.
By default each Node will open and maintain a maximum of 10 connections to the associated CAST Storage Service / PostgreSQL instance. Some of these connections may remain idle. If you would like to modify the number of open connections, particularly if you have multiple Nodes using the same CAST Storage Service / PostgreSQL instance, please see below.
Step 1 - Edit the configuration file
A configuration file (
aip-node-app.properties) must be edited to make these changes. This file is available on EACH Node, therefore if you have more than one Node, you will need to make this change on all Nodes.
To do so, first locate this file:
Edit the file with a text editor and locate the following lines:
CAST recommends keeping both options to the same value. Therefore if you decrease
database.server.maximumPoolSize, you should also decrease
database.server.minimumIdle to match. A technical explanation of each option is shown below:
|This property controls the minimum number of idle connections that the Node tries to maintain in the pool. If the idle connections dip below this value and total connections in the pool are less than |
This property controls the maximum size that the pool is allowed to reach, including both idle and in-use connections. Basically this value will determine the maximum number of actual connections to the CAST Storage Service / PostgreSQL instance. Default: 10
Save the file when the changes are complete.
Step 2 - Apply configuration changes
Restart the Nodes to ensure all changes are taken into account:
- If the Nodes are installed as Windows Services, restart the services
- If the Nodes are running only using the batch files, close the CMD windows to stop the processes, then restart then using the following file: