• PostgreSQL encryption options. All examples are based on the GA releases of MySQL CE (8.0) and PgSQL (13) available through official repositories using CentOS 8. Requirements The following is required on the real network interface. PostgreSQL settings for all modes can look like this: /var/lib/pgsql/13/data/postgresql.conf: ... ssl = on ssl_ca_file = 'root.crt' ssl_cert_file = 'server.crt' ssl_key_file ssl_prefer_server_ciphers = on ssl_min_protocol_version = 'TLSv1.3' ... For access control adjust /var/lib/pgsql/13/data/pg_hba.conf: 25 ... ### require hostssl all all 0.0.0.0/0 md5 ### verify CA hostssl all

used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. sqlite3 Required if SQLite is used as Oracle, PostgreSQL, SQLite One of the following modules must be installed: ibm_db2, mysql, oci8, pgsql, sqlite3 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled for Zabbix server and web frontend with PostgreSQL database. # yum install zabbix-server-pgsql zabbix-web-pgsql Creating initial database You need to have a database user with permissions to create database

used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. sqlite3 Required if SQLite is used as Oracle, PostgreSQL, SQLite One of the following modules must be installed: ibm_db2, mysql, oci8, pgsql, sqlite3 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled for Zabbix server and web frontend with PostgreSQL database. # yum install zabbix-server-pgsql zabbix-web-pgsql Creating initial database You need to have a database user with permissions to create database

used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Note: Zabbix may work on previous versions in addition to the import command for PostgreSQL, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server Zabbix proxy by running: # dnf install zabbix-proxy-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database Create a separate

used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Note: Zabbix may work on previous versions MySQL, Oracle, PostgreSQL, IBM DB2 One of the following modules must be installed: mysql, oci8, pgsql, ibm_db2 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled 6) with MySQL support: # yum install zabbix-web-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database For Zabbix

used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Note: Zabbix may work on previous versions MySQL, Oracle, PostgreSQL, IBM DB2 One of the following modules must be installed: mysql, oci8, pgsql, ibm_db2 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled 6) with MySQL support: # yum install zabbix-web-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database For Zabbix

PostgreSQL metrics A new item has been added to PostgreSQL plugin for Zabbix agent 2. The metric pgsql.queries is used for monitoring query execution time. The template PostgreSQL by Zabbix agent 2 has used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Note: Zabbix may work on previous versions Zabbix proxy by running: # dnf install zabbix-proxy-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database Create a separate

PostgreSQL metrics A new item has been added to PostgreSQL plugin for Zabbix agent 2. The metric pgsql.queries is used for monitoring query execution time. Templates The following templates have been used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Note: Zabbix may work on previous versions in addition to the import command for PostgreSQL, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u zabbix psql zabbix 78 Warning: TimescaleDB is supported with Zabbix

is used as Zabbix backend database. oci8 Required if Oracle is used as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. Third-party frontend libraries that are running: # dnf install zabbix-proxy-mysql zabbix-sql-scripts Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). The package ’zabbix-sql-scripts’ running: # apt install zabbix-proxy-mysql zabbix-sql-scripts Substitute ’mysql’ in the command with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3. The package ’zabbix-sql-scripts’ contains database

SNMPTrapperFile 否 tmp/zabbix_traps.tmp 时文件，用于传递 SNMP trap 守护进程的 数据给 server. 必须和 zab- bix_trap_receiver.pl 或 SNMPTT 配置文件 中的配置保持一致。 从 Zabbix 2.0.0 开始 支持该参数。 SNMPTrapperFile no /tmp/zabbix_traps.tmp Temporary passing data from SNMP trap daemon to the server. Must be the same as in zab- bix_trap_receiver.pl or SNMPTT configuration file. This parameter is supported since Zabbix 2.0.0. SocketDir 否 tmp SNMPTrapperFile 否 tmp/zabbix_traps.tmp 时文件，用于传递 SNMP trap 守护进程的 数据给 server. 必须和 zab- bix_trap_receiver.pl 或 SNMPTT 配置文件 中的配置保持一致。 从 Zabbix 2.0.0 开始 支持该参数。 SNMPTrapperFile no /tmp/zabbix_traps.tmp Temporary