Ad Widget

Collapse

Problem with silent update of timescaledb

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mad_man
    Junior Member
    • Nov 2020
    • 2

    #1

    Problem with silent update of timescaledb

    zabbix-server: 6.0.18
    postgresql-server: 14
    Found that the timescaledb extension is updating silently and without notifications. The server worked for a long time without rebooting, after rebooting zabbix-server did not start, in the database the following:

    zabbix=# SELECT default_version, installed_version FROM pg_available_extensions
    zabbix-# where name = 'timescaledb';
    default_version | installed_version
    -----------------+-------------------
    2.7.2 | 2.7.2
    The maximum supported version for TimescaleDB is now 2.6.

    I successfully downgraded timescaledb to 2.6.1, but zabbix-server still won't start. I don't remember what version timescaledb was at the time of initial installation (it was September 2022).

    Can you tell me how to disable the timescaledb extension and leave clean postgresql, without completely reinstalling the database? I am ready for loss of history and trends.
Working...