Help on upgrading to Zabbix 7.0 with partitioned tables with PostgreSQL 14
Hi,
We're trying to upgrade from Zabbix 6.2 to Zabbix 7.0 with PostgreSQL 14 and partitioned history/trends tables.
We have a large amount of data and we would like to manually run the patch for "database upgrade to primary keys and double precision data types" as seen here:
I believe we have to do this anyways, because of the partitioning and the way the standard upgrade SQL scripts work.
Does anyone know how to adapt the history_upgrade_prepare.sql script and the procedure of "migration with stopped server" that follows?
Thanks on advance!
We're trying to upgrade from Zabbix 6.2 to Zabbix 7.0 with PostgreSQL 14 and partitioned history/trends tables.
We have a large amount of data and we would like to manually run the patch for "database upgrade to primary keys and double precision data types" as seen here:
I believe we have to do this anyways, because of the partitioning and the way the standard upgrade SQL scripts work.
Does anyone know how to adapt the history_upgrade_prepare.sql script and the procedure of "migration with stopped server" that follows?
Thanks on advance!