### Option: HousekeepingFrequency
# How often Zabbix will perform housekeeping procedure (in hours).
# Housekeeping is removing outdated information from the database.
# To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency
# hours of outdated information are deleted in one housekeeping cycle, for each item.
# To lower load on server startup housekeeping is postponed for 30 minutes after server start.
# With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option.
# In this case the period of outdated information deleted in one housekeeping cycle is 4 times the
# period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days.
#
# Mandatory: no
# Range: 0-24
# Default:
# HousekeepingFrequency=1

### Option: MaxHousekeeperDelete
# The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
# [housekeeperid], [tablename], [field], [value].
# No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
# will be deleted per one task in one housekeeping cycle.
# If set to 0 then no limit is used at all. In this case you must know what you are doing!
#
# Mandatory: no
# Range: 0-1000000
# Default:
# MaxHousekeeperDelete=5000

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)

sudo -u postgres psql zabbix

SELECT * FROM pg_extension WHERE extname = 'timescaledb';

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)

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.

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

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

shared_preload_libraries = 'timescaledb'

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

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