Red Hat 9.4 / Zabbix 7.0.0rc1 / PostGreSql 16 / timescaledb_16

[zabbixuser39393]

Problem is this. How I can download earlier version 2.14.2 and "clean up" database or set up again to 2.14.2?

dnf info timescaledb_16.x86_64
Updating Subscription Management repositories.
Red Hat Satellite Client 6 for RHEL 9 x86_64 (RPMs) 92 kB/s | 3.8 kB 00:00
Red Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 109 kB/s | 4.1 kB 00:00
Red Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 116 kB/s | 4.5 kB 00:00
timescale_timescaledb 213 B/s | 833 B 00:03
Available Packages
Name : timescaledb_16
Version : 2.15.0
Release : 1PGDG.rhel9
Architecture : x86_64
Size : 350 k
Source : timescaledb_16-2.15.0-1PGDG.rhel9.src.rpm
Repository : pgdg16
Summary : PostgreSQL based time-series database
URL : https://github.com/timescale/timescaledb
License : Apache
Description : TimescaleDB is an open-source database designed to make SQL scalable for
: time-series data. It is engineered up from PostgreSQL, providing automatic
: partitioning across time and space (partitioning key), as well as full SQL
: support.

[cyber]

https://www.cyberciti.biz/faq/howto-...entific-linux/
https://unix.stackexchange.com/quest...n-of-a-package
etc... GIYF...

[zabbixuser39393]

Thanks Cyber. I also found this

Zabbix 7.0 - instructions for installation in 5 minutes - initMAX s.r.o.

and there was text:

If you see a message in the log file that the TimescaleDB version is too new, then this is not a problem at the time of writing this tutorial. Because Zabbix has not yet responded to the latest version of TimescaleDB by setting it as supported one in its code, but compatibility is guaranteed by Zabbix and verified by us (this will be corrected in the production version).
If you want to avoid these informational messages about incompatibility in the Zabbix log file, then just open the configuration file of the Zabbix server in the path /etc/zabbix/zabbix_server.conf and edit the following configuration parameter as can be seen in code block here: AllowUnsupportedDBVersions=1

Save the file with this setting and restart the Zabbix server system service. systemctl restart zabbix-server

p.s. I think that version of timescaledb was 2.14.x at time of when article was writed. Maybe it will work also with version 2.15?

[cyber]

Your question was "how to downgrade", not "will it work"... Like a question , like the answer... It might work also in this case.

[zabbixuser39393]

Downgrade timescale extension version · Issue #1800 · timescale/timescaledb · GitHub - How to add exact version of timescaledb ->

create extension timescaledb version '2.14.2';

then

Goto /usr/share/zabbix-sql-scripts/database/postgresql/timescaledb/ and run
cat schema.sql | sudo -u zabbix psql zabbix