Zabbix upgrade from 5.4.12 to 6.4

[Madiar]

I have checked the documentation and forums but have not found a solution. Please help me understand. The question and configuration are below:

Question: I need to upgrade Zabbix from 5.4.12 to 6.4. Will there be any issues during the database upgrade if partitions for the history and history_uint tables were manually created in the current database?

Configuration:

• Zabbix server, Zabbix web, and Zabbix database are on separate VMs.
• Zabbix server: 5.4.12, Platform: Debian GNU/Linux 10
• Database: PostgreSQL 13.4, Platform: Debian GNU/Linux 10
• Zabbix web: nginx/1.14.2, PHP 7.3.29-1, Platform: Debian GNU/Linux 10

Thank you.

[Markku]

When you say the database partitions were created manually and you only mention PostgreSQL (and not TimescaleDB), does that mean that you are not using TimescaleDB extension but some other way of partitioning the tables?

(I don't do PostgreSQL with Zabbix but someone else may be able to comment better then)

Markku

[Madiar]

manually means using sql commands, may be the picture will help to understand

[Markku]

This sounds like similar setup that is needed with MySQL/MariaDB (but someone PostgreSQLista please confirm): no native support in Zabbix to maintain the partitions. (Ref: https://blog.zabbix.com/partitioning...cedures/13531/)

If that is the case, then Zabbix does not care about the partitioning, it is just an internal implementation detail of the database engine, some other party takes care of the partition maintenance. Thus the Zabbix software upgrade should work normally.

Of course it is advised the arrange a similarly configured copy of the database and test it offline, before actually upgrading it in-place (and have backups up-to-date nevertheless).

Markku

[Madiar]

ok thank you for you reply, hope upgrade will be finished successfully)
Could you also tell me, if the size of the database is 8TB, how long the upgrade process will take?

[Markku]

Could you also tell me, if the size of the database is 8TB, how long the upgrade process will take?

Impossible to say, it depends on for example your database settings/performance and the amount of actual data in the database. You'll only know it after the fact (= testing or prod). Might be days, cannot tell.

Markku

[Markku]

In addition to the other upgrade documentation, note also this:

https://www.zabbix.com/documentation/6.4/en/manual/appendix/install/db_primary_keys

Markku

[Madiar]

days? sounds scarry) below the configuration of VMs. Is it possible to approximately forcast how much time it takes?


zabbix-db-01:
Size Used Avail Use%
9.8T 7.5T 2.3T 77%

[Madiar]

also regarding primary keys can I skip this step? as I read in manuals it is optional step.