The history_bin
table has been converted to hypertable on TimescaleDB to benefit from automatic partitioning on time (1 day by default) and better performance.
To successfully upgrade existing installations, see Upgrading TimescaleDB schema.
See also: Supported TimescaleDB versions
Using pg_restore
to restore a PostgreSQL/TimescaleDB backup created in Zabbix 7.0.0-7.0.4 will result in a missing base36_decode
function error, causing the restore to fail. This error occurs when restoring a backup created with pg_dump
.
See known issues for details on fixing this issue manually before creating the backup.
If you have not upgraded to Zabbix 7.0.0 yet, note that there should be no such issues for upgrades from pre-7.0 Zabbix versions to 7.0.5. For upgrade instructions, see Upgrading TimescaleDB schema.