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

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 = 220
This is a minimum recommended value, you can specify a larger one.
max_parallel_workers_per_gather = 0
maintenance_work_mem = 128MB

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.

The Postgres role used by the Server to access the DBMS needs to have privileges to read the following views (enabled by default):

pg_stat_replication
pg_stat_wal_receiver