Please add timescaledb 2.15 to Zabbix 7.0

[zabbixuser39393]

Timescaledb repository for Red Hat 9.(4) installs timescaledb version 2.15 for PostGreSql 16. Zabbix-server does not start for that.

[krejzymanky]

Hello,

There is route to downgrade TimescaleDB instance but I don't have experience with that.
For now just enable the AllowUnsupportedDBVersions parameter in your zabbix_server.conf. It works fine.

[eertul]

There's an option in zabbix-server.conf as AllowUnsupportedDB. If you set it to 1, server starts but it's still unsupported.

[cyber]

hmm... Z7rc1, PG16.3 and TS2.15, no complaints or errors whatsoever... AllowUnsupportedDB is not set..

[zabbixuser39393]

7 rc 3: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix <- does not work. timescaledb.sql not exists any more?

[sdutill]

7 rc 3: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix <- does not work. timescaledb.sql not exists any more?

I just worked through this issue over the last week. timescaledb.sql has been moved to a new file in the timescaledb directory: /usr/share/zabbix-sql-scripts/postgresql/timescaledb/schema.sql.

Maybe I've got it set up wrong and can't tell, but my instance is working and I'm able to enable compression, though I get a warning about the version of Timescale I'm using.

[Tristis Oris]

Wasted a lot time for migration, just to get that ubuntu 24 have no 2.14 timescale support, and zabbix have no ts 2.15 support.
Unable to upgrade 6>7 on ubuntu22, due missiing dependencies T_o, unable perform migration to new host. Tripple win.

[Markku]

Unable to upgrade 6>7 on ubuntu22, due missiing dependencies

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/485266-broken-packages-while-updating-from-6-4-to-7#post485635

Markku

[Tristis Oris]

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/485266-broken-packages-while-updating-from-6-4-to-7#post485635

Markku

weid, but it works now.

has been moved to a new file in the timescaledb directory: /usr/share/zabbix-sql-scripts/postgresql/timescaledb/schema.sql.

nothing for me.

/usr/share/zabbix-sql-scripts/postgresql# ls
double.sql history_pk_prepare.sql proxy.sql server.sql.gz timescaledb.sql tsdb_history_pk_upgrade_no_compression tsdb_history_pk_upgrade_with_compression

pg16, timescale 2.14.2

[LIST][*]The Zabbix database version does not match current requirements. Your database version: 6040000. Required version: 7000000. Please contact your system administrator.[/LIST]

[Tristis Oris]

nothing for me.

yeah sure, documentation wrong again.
https://www.zabbix.com/documentation...bix-components

apt-get install --only-upgrade zabbix-server-pgsql zabbix-frontend-php zabbix-agent​

when you need

zabbix-server-pgsql zabbix-frontend-php php8.1-pgsql zabbix-nginx-conf zabbix-sql-scripts zabbix-agent​

scripts updated now, 7.0 is running. Also need to wait for background migration, not obvious.

[cyber]

Well "php8.1-pgsql" is not exactly Zabbix package. They cannot tell you to upgrade/install something that might or might not be already there. Resolving requirements is your responsibility...

I do admit, that sometimes it might be difficult to navigate through all the requirements in all kind of distros....

[Tristis Oris]

Well "php8.1-pgsql" is not exactly Zabbix package.

that official command from download page.

[zabbix777]

Wasted a lot time for migration, just to get that ubuntu 24 have no 2.14 timescale support, and zabbix have no ts 2.15 support.
Unable to upgrade 6>7 on ubuntu22, due missiing dependencies T_o, unable perform migration to new host. Tripple win.

Did you manage to update Zabbix 7.0.1 on Ubuntu 24.04 with postgres+timescale?

[cyber]

that official command from download page.

Ok, I stand corrected, but it is "Install commands" not "upgrade commands"... When you upgrade you probably already have php installed. Anyway, it far off from the topic of Timescale.. Hopefully required version will be added with first patch release...

Did you manage to update Zabbix 7.0.1 on Ubuntu 24.04 with postgres+timescale?

There is no 7.0.1 yet... give it couple of weeks. And as you can read couple of posts above, that upgrade finally succeeded with additional php updates..:P

[zabbix777]

Ok, I stand corrected, but it is "Install commands" not "upgrade commands"... When you upgrade you probably already have php installed. Anyway, it far off from the topic of Timescale.. Hopefully required version will be added with first patch release...

There is no 7.0.1 yet... give it couple of weeks. And as you can read couple of posts above, that upgrade finally succeeded with additional php updates..:P

I reinstalled postgres along with rebuilding the Zabbix database. I’ll forget about timescale like a bad dream.