[comment]: # translation:outdated

[comment]: # ({new-1bd9e66f})
# 13 Upgrade notes for 7.0.2

:::notewarning
Zabbix 7.0.2 is not released yet.
:::

This minor version does not have any upgrade notes.

[comment]: # ({/new-1bd9e66f})

[comment]: # ({new-49f0b2ec})
## Breaking changes

[comment]: # ({/new-49f0b2ec})

[comment]: # ({new-9afd8363})
#### 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](#binary-data-history-converted-to-hypertable-on-timescaledb).

See also:

-   [TimescaleDB setup](/manual/appendix/install/timescaledb#configuration)
-   [Supported TimescaleDB versions](/manual/installation/requirements#third-party-external-surrounding-software)

[comment]: # ({/new-9afd8363})

[comment]: # ({new-b7e1210c})
#### Database restore error with PostgreSQL/TimescaleDB after upgrade from 7.0.0-7.0.4

Using [`pg_restore`](https://www.postgresql.org/docs/current/app-pgrestore.html) 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`](https://www.postgresql.org/docs/current/app-pgdump.html).

See [known issues](/manual/installation/known_issues#database-restore-error-with-postgresqltimescaledb-after-upgrade-from-7.0.0-7.0.4) 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](/manual/appendix/install/timescaledb#upgrading-timescaledb-schema).

[comment]: # ({/new-b7e1210c})