Help to check if my Postgres DB is running TimescaleDB correctly please

[G0nz0uk]

Hello,

We are using Zabbix v7.4.8 with Postgres v18 and TSDB.

How can I tell Postgres is using TSDB or the correct verison please?

If I run I get this installed version:

sudo -u postgres psql -c "SELECT default_version, installed_version FROM pg_available_extensions WHERE name = 'timescaledb';"
default_version | installed_version
-----------------+-------------------
2.24.0 |
(1 row)

However if I log into the Zabbix database

sudo -u postgres psql zabbix

and run

SELECT * FROM pg_extension WHERE extname = 'timescaledb';

I see 2.23.0

oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+-------------+----------+--------------+----------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------
22287 | timescaledb | 10 | 2200 | f | 2.23.0 | {22313,22314,22347,22364,22363,22388,22387,22407,2 2406,22440,22458,22460,22459,22485,22486,22572,225 91,22628,22645,22657,22669,22676,22687,22708,22720 ,22744,22755,22754} | {"","WHERE id >= 1","","","","","","","","","","","","","WHERE id >= 1000"," WHERE key <> 'uuid' ","","","","","","","","","","","",""}
(1 row)

Installed on the Ubuntu server:

dpkg -l | grep timescaledb
hi timescaledb-2-loader-postgresql-18 2.24.0~ubuntu24.04-1801 amd64 The loader for TimescaleDB to load individual versions.
hi timescaledb-2-postgresql-18 2.24.0~ubuntu24.04-1801 amd64 An open-source time-series database based on PostgreSQL, as an extension.
ii timescaledb-toolkit-postgresql-18 1:1.22.0~ubuntu24.04 amd64 Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities, compatible with TimescaleDB and PostgreSQL
ii timescaledb-tools 0.18.1~ubuntu24.04 amd64 A suite of tools that can be used with TimescaleDB.

When the server was build we used the

sudo apt install -y timescaledb-2-postgresql-18

sudo timescaledb-tunetimescaledb-tune --version
timescaledb-tune 0.18.1 (linux amd64)

In the postgresql.conf I have

shared_preload_libraries = 'timescaledb'

Test

sudo -u postgres psql -c "SHOW shared_preload_libraries;"
shared_preload_libraries
--------------------------
timescaledb
(1 row)

To original install Timescale DB onto the Zabbix DB I ran:

echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbixcat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix

Maybe it all looks ok, but I'm a novice at Postgres and TSDB and help would be great.

Thanks

[cyber]

If you upgraded TS version you may need to run also "ALTER EXTENSION timescaledb UPDATE;"

If \dx will tell you the same version number as you have installed, then it should be OK.

[cyber]

If you upgraded TS version you may need to run also "ALTER EXTENSION timescaledb UPDATE;"

If \dx will tell you the same version number as you have installed, then it should be OK.

[G0nz0uk]

That did the trick thanks.