database versions are officially supported: • MySQL/Percona 8.0.X • MariaDB 10.5.X - 10.6.X • PostgreSQL 13.X - 14.X • Oracle 19c - 21c • TimescaleDB 2.0.1-2.3 • SQLite 3.3.5-3.34.X By default, Zabbix history tables to primary keys in pre-existing installations are available for MySQL/MariaDB, PostgreSQL, TimescaleDB v1 and v2, and Oracle. 14 utf8mb4 support for MySQL utf8mb4 encoding with utf8mb4_bin and open the hints, using the keyboard. 8 What’s new in Zabbix 6.0.3 PostgreSQL metrics A new item has been added to PostgreSQL plugin for Zabbix agent 2. The metric pgsql.queries is used for monitoring

approximately 15 digits and range from approximately -1.79E+308 to 1.79E+308 (with exception of PostgreSQL 11 and earlier versions). This is by default for new installations. For upgraded installations connections to Zabbix database It is now possible to configure secure TLS connections to MySQL and PostgreSQL databases from: • Zabbix frontend • Zabbix server or proxy Restricting agent checks It is possible MariaDB 10.0.37 • PostgreSQL 9.2.24 • Oracle 11.2 TimescaleDB native compression support TimescaleDB native compression is now supported in Zabbix server installations with PostgreSQL version 10.2 or

by HTTP, which includes OpenStack Nova by HTTP template for monitoring OpenStack Nova service • PostgreSQL by ODBC You can get these templates: • In Data collection → Templates in new installations; versions PostgreSQL 16 and MariaDB 11.1 are now supported. See also: Requirements. Plugins New item for PostgreSQL Zabbix agent 2 plugin New item, pgsql.version, has been added to PostgreSQL Zabbix agent agent 2 plugin. This item is used for returning the PostgreSQL version. Templates New templates New templates are available: • FortiGate by HTTP • FortiGate by SNMP • Nextcloud by HTTP You can get

database versions are officially supported: • MySQL/Percona 5.7.28-8.0.X • MariaDB 10.0.37-10.5.X • PostgreSQL 10.9-13.X • Oracle 12.1.0.2 - 19c • TimescaleDB 1.5-2.1 • SQLite 3.3.5-3.34.X Direct connections to monitor validity and expiration dates of TLS/SSL website certificates. • Plugins MySQL and PostgreSQL now support encrypted TLS connection between the agent and monitored databases. TLS encryption setting. 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

upgrade existing installations, you must rerun the timescaledb.sql script, located in database/postgresql, before starting Zabbix server. Zabbix server will log a warning, if started without running this separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle is at your own risk and may contain some limitations as, for example, in return MySQL Server, Percona Server, MariaDB Server, PostgreSQL m6i.large/m6g.large Medium 10 000 4 16 MySQL Server, Percona Server, MariaDB Server, PostgreSQL m6i.xlarge/m6g.xlarge Large 100 000 16 64 MySQL

Oracle, and Redis plugins, a Uri can now only be specified as a named session parameter. • For PostgreSQL plugin a Uri and Database name can now only be specified as a named session parameter. • For Uri webhook, hardcoded teams_endpoint check has been removed to prevent URL syntax error. PostgreSQL plugin • PostgreSQL plugin for Zabbix agent 2 now supports custom queries; • Unix socket support has 10 supported in addition to Timescale DB 1.X. Please note, that Timescale DB 2.X works only with PostgreSQL 11 or newer. 15 What’s new in Zabbix 5.2.7 Improved Slack webhook JavaScript in Slack webhook

，会保留其父链接，而不会保留子链接。 主键 主键现在用于新安装中的所有表，包括历史表。 现有安装不会自动升级主键。在现有安装中 手动升级历史表主键的说明适用于MySQL/MariaDB、PostgreSQL、TimescaleDB v1 和v2 以 及Oracle。 新增小部件 新版本中添加了以下几个仪表板小部件。 Top 主机 Top hosts 小部件被添加到仪表板小部件中。此小部件旨在替换弃用的 的未修复问题的版本。 从 Zabbix 6.0 开始，官方支持以下数据库 版本： • MySQL/Percona 8.0.X • MariaDB 10.5.X - 10.6.X • PostgreSQL 13.X - 14.X • Oracle 19c - 21c • TimescaleDB 2.0.1-2.3 • SQLite 3.3.5-3.34.X 默认情况下，如果检测到不支持的数据库版本，Zabbix 现在包含内存池和垃圾回收器的低级别自动发现规则。 键盘导航 已对前端的信息图标实施键盘控制。现在是这样可以专注于信息图标，并使用键盘打开提示。 8 Zabbix 6.0.3 新功能 PostgreSQL 指标 Zabbix agent 2 的 PostgreSQL 插件中添加了一个新的监控项。指标 pgsql.queries 用于监控查询执行时间。 模板 新模板 OpenWeatherMap by HTTP 现在可以通过

maximum supported version for TimescaleDB is now 2.8. PostgreSQL 15 support PostgreSQL 15 is now supported. Note that TimescaleDB does not support PostgreSQL 15 yet. Possible to build Zabbix agent 2 offline using go mod tidy or go get commands. PostgreSQL plugin loadable The PostgreSQL plugin is now loadable in Zabbix agent 2 (previously built-in). See also: PostgreSQL loadable plugin repository 14 Extended Azure by HTTP has been updated and now includes metrics to monitor Microsoft PostgreSQL flexible servers and Microsoft PostgreSQL single server out-of-the-box. You can get this template: • In Configuration

-uzabbix -p zabbix < images.sql shell> mysql -uzabbix -p zabbix < data.sql PostgreSQL 需要使用有权限的用户去创建数据库对象。以下 shell 命令将创建 zabbix 用户。在提示下请输入密码并再次确认密码。（注意，可能首 先要求输入 sudo 命令对应的用户密码）： You instructions for Debian/Ubuntu or RHEL/CentOS to import the data into the database. shell> cd database/postgresql shell> cat schema.sql | sudo -u zabbix psql zabbix # 下 面 步 骤 当 创 建Zabbix proxy数 据 库 时 不 需 要 执 行 connections between: Database Zabbix components MySQL Zabbix frontend, Zabbix server, Zabbix proxy PostgreSQL Zabbix frontend, Zabbix server, Zabbix proxy To set up connection encryption within the DBMS,

日志文件以确认数据库升级是否成功；如果成功，停止 Zabbix server，然后进行下一步。 3. 运行 postgresql/timescaledb/schema.sql 脚本（从 Zabbix 7.0.0 开始，脚本的位置和名称已从 postgresql/timescaledb.sql 更改为 postgresql/timescaledb/schema.sql）。请注意，如果没有运行此脚本而启动 Zabbix next step. 3. Run the postgresql/timescaledb/schema.sql script (since Zabbix 7.0.0, the script’s location and name has been changed from postgresql/timescaledb.sql to postgresql/timescaledb/schema.sql) 是无需本地管理员即可集中监控远程位置、分支机构和网络的理想解决方案。 Zabbix proxy 需要使用独立的数据库。 Attention: 值得注意的是，Zabbix proxy 支持 SQLite、MySQL 和 PostgreSQL 作为数据库。使用 Oracle 或 DB2 需要您承担一定的风险， 例如，在低级别自动发现规则中的返回值 。 详见：在分布式环境中使用 Zabbix proxy。 运行 Proxy 如果通过包安装