(compatible with both TSDB v2.x and v1.x version) based on compression settings: – If compression is enabled (on default installation), run scripts from database/postgresql/tsdb_history_pk_upgrade_with_compression: /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_uint /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_log.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compre

(compatible with both TSDB v2.x and v1.x version) based on compression settings: – If compression is enabled (on default installation), run scripts from /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_uint /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_log.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compre

(compatible with both TSDB v2.x and v1.x version) based on compression settings: – If compression is enabled (on default installation), run scripts from /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_uint /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_log.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compre

TimescaleDB 超表迁移脚本（兼容 TSDB v2.x 和 v1.x 版本）：·* 如果启用了压缩（默认安装），从 database/postgresql/tsdb_history_pk_upgrade_with_compression 运行脚本：·{.bash} · cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgra /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_uint.sql | sudo -u zabbix psql zabbix · cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compr /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compression/history_pk_str.sql | sudo -u zabbix psql zabbix · cat /usr/share/zabbix-sql-scripts/postgresql/tsdb_history_pk_upgrade_with_compr

可选文件或补丁升级数据库表 位于 option-patches 目录。 • 数据库扩展和加载项现在作为子目录，在相应的数据库目录中，以扩展名命名。 • TimescaleDB 相关变化： – tsdb 缩写已经修改为 timescaledb。 – option-patches 目录包含 with-compression 和 without-compression 子目录；包含可选的文件或补丁，用于升 ￿￿￿ schema.sql ￿ ￿￿￿ images.sql ￿ ￿ ￿￿￿ schema.sql ￿ ￿ 119 ￿￿￿ postgresql ￿￿￿ postgresql ￿ ￿￿￿ tsdb_history_pk_upgrade_no_compression ￿ ￿￿￿ option-patches ￿ ￿ ￿￿￿ history_pk.sql ￿ ￿ ￿￿￿ double.sql history_pk_text.sql ￿ ￿ ￿￿￿ option-patches ￿ ￿ ￿￿￿ history_pk_uint.sql ￿ ￿ ￿ ￿￿￿ with-compression ￿ ￿￿￿ tsdb_history_pk_upgrade_with_compression ￿ ￿ ￿ ￿ ￿￿￿ history_pk.sql ￿ ￿ ￿￿￿ history_pk.sql ￿ ￿ ￿ ￿ ￿￿￿

| sudo -u zabbix psql zabbix • Run TimescaleDB hypertable migration scripts (compatible with both TSDB v2.x and v1.x version) based on compression settings: – If compression is enabled (on default installation)