Configuring the PostgreSQL or Postgres Pro server for working with Open Single Management Platform

To successfully configure PostgreSQL or Postgres Pro server for working with Administration Server, you must use the default server parameters except for the server parameters specified in this article.

Kaspersky Next XDR Expert supports PostgreSQL or Postgres Pro database management systems (DBMS). For the full list of supported DBMSs, refer to the Hardware and software requirements. Consider configuring the DBMS server parameters to optimize the DBMS work with Administration Server.

The default path to the configuration file is: /etc/postgresql/<VERSION>/main/postgresql.conf

Recommended parameters for PostgreSQL and Postgres Pro DBMS for work with Administration Server:

shared_buffers = N
N = 25% of the RAM value of the device where the DBMS is installed. If RAM is less than 1 GB, then leave the default value.
max_stack_depth = N
If the DBMS is installed on a Linux device, then N = maximum stack size minus the 1 MB safety margin. To obtain the maximum stack size value in KB, execute the 'ulimit -s' command.

If the DBMS is installed on a Windows device, then leave the default value 2 MB.
temp_buffers = 24MB
work_mem = 16MB
max_connections = 512
This is a minimum recommended value, you can specify a larger one.
max_parallel_workers_per_gather = 0
maintenance_work_mem = 128MB

Make sure the standard_conforming_strings parameter is set to its default value of on. Reload configuration or restart the server after updating the postgresql.conf file. Refer to the PostgreSQL documentation for details.

If you use a cluster Postgres DBMS, specify the max_connections parameter for all DBMS servers as well as in the cluster configuration.

If you use Postgres Pro 15.7 or Postgres Pro 15.7.1, disable the enable_compound_index_stats parameter:

enable_compound_index_stats = off

For detailed information about PostgreSQL and Postgres Pro server parameters and on how to specify the parameters, refer to the corresponding DBMS documentation.

Highly available cluster support

Highly available PostgreSQL clusters are supported with the following settings:

Replication type: synchronous.

Minimum number of nodes: 3.

Maximum number of nodes: 15.

Set the psql_dsn parameter as follows: postgres://<dbms_username>:<password>@<fqdn1>:<port>,<fqdn2>:<port>,<fqdn3>:<port>

When using a Postgres Highly Available cluster version 14 or later as the database, the database user must have the pg_read_all_stats privilege. You can grant this privilege by running the following command:

GRANT pg_read_all_stats TO "dbms_username";

Where dbms_username is the name of a privileged internal DBMS account.

Specify the following parameter in the configuration file (/etc/postgresql/<VERSION>/main/postgresql.conf):

log_hostname = 1