Kaspersky Security Center 15.1 supports PostgreSQL and Postgres Pro DBMSs. If you use one of these DBMSs, consider configuring the DBMS server parameters to optimize the DBMS work with Kaspersky Security Center.
The default path to the configuration file is: C:\Program Files\PostgreSQL\<
VERSION
>\data\postgresql.conf
Recommended parameters for PostgreSQL and Postgres Pro:
shared_buffers =
25 percent of the RAM value of the device where the DBMS is installedIf RAM is less than 1 GB, then leave the default value.
max_stack_depth =
2MB
temp_buffers =
24MB
work_mem =
16MB
max_connections =
151
max_parallel_workers_per_gather =
0
maintenance_work_mem =
128 MB
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 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 them, refer to the corresponding DBMS documentation.
Refer to the following topic for details on how to create and configure accounts for PostgreSQL and Postgres Pro: Configuring accounts for work with PostgreSQL and Postgres Pro.
Highly available cluster support
Highly available PostgreSQL clusters are supported. To use the functionality, run the following command to enable the KLCS_FF_SUPPORT_POSTGRES_FAIILOVER flag:
sudo /opt/kaspersky/ksc64/sbin/klscflag -fset -pv ".core/.independent" -s klcsff -n KLCS_FF_SUPPORT_POSTGRES_FAIILOVER -t d -v 1
The Postgres role used by the Server to access the DBMS needs to have privileges to read the following views (enabled by default):