13 Upgrade notes for 7.0.2

This minor version does not have any upgrade notes.

Breaking changes

Binary data history converted to hypertable on TimescaleDB

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:

1. Start Zabbix server; this will upgrade the existing database.
2. Check the server log file that the database upgrade has been successful; if so, stop Zabbix server and proceed to the 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). Note that Zabbix server will log a warning if started without running this script.

See also:

• TimescaleDB setup
• Supported TimescaleDB versions

Database restore error with PostgreSQL/TimescaleDB after upgrade from 7.0.0-7.0.4

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.