[ZBX-23301] Incompatible TimescaleDB version listed as supported in documentation Created: 2023 Aug 22  Updated: 2024 Apr 10  Resolved: 2024 Mar 01

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Documentation (D), Frontend (F), Server (S)
Affects Version/s: 6.0.21rc1, 6.4.6rc1, 7.0.0alpha4
Fix Version/s: 6.0.23rc1, 6.4.8rc1, 7.0.0alpha6, 7.0 (plan)

Type: Problem report Priority: Trivial
Reporter: Janis Nulle Assignee: dimir
Resolution: Fixed Votes: 0
Labels: Supported, TimescaleDB, documentation, version
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File ZBX-23301.png    
Issue Links:
Sub-task
depends on ZBXNEXT-8570 Remove TimescaleDB v1.x support Closed
Team: Team A
Sprint: Sprint 103 (Aug 2023), Sprint 104 (Sep 2023), Sprint 105 (Oct 2023), Sprint 106 (Nov 2023), Sprint 107 (Dec 2023), Sprint candidates, S2401
Story Points: 1

 Description   

In documentation article Requirements versions 2.0.1 to 2.11 for TimescaleDB are listed as supported. Version 2.0.1 of TimescaleDB does not support PostgreSQL 13.0, which is another requirement for Zabbix. More info on supported PSQL versions here.

Additionally, when trying to build Timescale 2.0.1 on a machine with PostgreSQL 13 you get this error:

-- Compiling against PostgreSQL version 13.12
CMake Error at CMakeLists.txt:244 (message):
  TimescaleDB only supports PostgreSQL 11 and 12


-- Configuring incomplete, errors occurred!

Support for PostgreSQL 13 was added on TimescaleDB version 2.1.0 - release notes here. The oldest supported TimescaleDB version should be changed to 2.1.0.

Note: this also means changes in Server and Frontend checks. Server checks DB version when starting. Frontend shows a warning in Administration -> Housekeeping when the version is not supported.

 Comments   
Comment by dimir [ 2023 Sep 07 ]

OK, this makes sense. Currently in the code we differentiate 3 things:

  • PostgreSQL version
  • TimescaleDB extension version
  • Combination of PostgreSQL-TimescaleDB extension versions

Since TimescaleDB version 2.0 (as jnulle mentions) the latter becomes much more complicated:

So we decided we remove that check, we will only check separately:

  • PostgreSQL version
  • TimescaleDB extension version
Comment by dimir [ 2023 Sep 07 ]

Fixed in development branch for 6.0 .

Comment by dimir [ 2023 Sep 29 ]

Overview

The check for PostgreSQL-TimescaleDB versions combination was removed since from TimescaleDB version 2.0 this became too complicated. Zabbix will only check the PostgreSQL and TimescaleDB versions independently.

Fixed in

Comment by Martins Valkovskis [ 2023 Oct 04 ]

Updated documentation:

  • Requirements: 6.0, 6.4, 7.0 (TimescaleDB minimum supported version raised to 2.1.0)
  • Upgrade notes: 6.0.23, 6.4.8
Comment by LivreAcesso.Pro [ 2023 Oct 24 ]

Please, update TimescaleDB to 2.12.2:

Package: timescaledb-2-loader-postgresql-14
Version: 2.12.2~debian11
Priority: optional
Section: database
Source: timescaledb-2-2.12.2-postgresql-14
Maintainer: Timescale <[email protected]>
Installed-Size: 291 kB
Depends: postgresql-14, libc6 (>= 2.4)
Recommends: timescaledb-tools
Homepage: https://timescale.com
Download-Size: 92,0 kB
APT-Sources: https://packagecloud.io/timescale/timescaledb/debian bullseye/main amd64 Packages
Description: The loader for TimescaleDB to load individual versions.
 An open-source time-series database optimized for fast ingest and complex queries.
 Engineered up from PostgreSQL, packaged as an extension.
Generated at Sun May 11 07:32:46 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.