TSDB native compression option missing in housekeeping section

[supafly]

Hello!
Sorry if it is a duplicate, haven't find a solution on forum.
My setup:
Core - Zabbix server 6.0.42
DB - PostgreSQL 15.14 + TimescaleDB 2.22.0
Web - docker image zabbix/zabbix-web-nginx-pgsql:centos-6.0-latest

I've successfully migrated 5TB database...

[cezve]

Hi, everyone. I try to use timescaledb.

There is a explanation about it Zabbix help document say;

"To successfully remove compressed data by housekeeper, both Override item history period and Override item trend period options must be enabled. If override is disabled and...

[dieselfluxcapacitor]

I am trying to understand the correct way to migrate my old Zabbix PostgreSQL database to a new PostgreSQL server. My attempts to migrate the database have not been successful and I anticipate it has to do with TImescaleDB.

ENVIRONMENT:
SERVER A (old database server)

• Zabbix 6.4
• Ubuntu

...

[shafuq]

I've setup a Zabbix central server with a few proxies. All of them have postgresql as their db. (ubuntu/nginx/postgresql/zbx7.0.5)

The servers have the following resources:
- zabbix_server: 4xCore, 16GB RAM, 100GB Disk
- zabbix_proxies: 2xCore, 8GB RAM, 60GB Disk.
...

[shafuq]

So I'm trying to setup timescaledb on my new zabbix installation:

Zabbix 7.0 > Ubuntu > 24.04 > Server > postgresql > nginx

I can't find anything online for this specific combination regarding zabbix7+timescaledb - Only RHEL-Based guides out there.
...

[Tristis Oris]

zabbix 7.x, can't migrate database according to https://docs.timescale.com/migrate/l...p-and-restore/

COPY 0
COPY 0
COPY 0
psql:/opt/dump.sql:14105578: ERROR: function base36_decode(text) does not exist
LINE 1: CAST(base36_decode(substring(cuid FROM

...

[ruryx00]

hello everyone i have an installation of zabbix server in version 6.4 using postgresql+timescaledb as database.
I would like to perform an update of both the server and the database without losing my data.
more information about my setup:

• Postgres 14.2
• Timescaledb 2.12.2
• zabbix server

...

[mad_man]

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:



The maximum supported version for TimescaleDB is now 2.6....

[Eugene Mihaylovsky]

Hello. I got incident connected with our Zabbix. Last night i was called from our l1 support request that our monitoring didn't work. I went on different metrics and queryes and noticed a strange behavior.
In one moment out database got 100 hundred million select in a second for 20 min. This query...

[wyang]

I am a beginner of PostgreSQL and TimescaleDB. As per TimescaleDoc https://docs.timescale.com/self-host...ntire-database, the command to backup a database named tsdb is

pg_dump -Fc -f tsdb.bak tsdb​

which uses '-Fc' option (output file format custom).

I was wondering...

[Alfista]

Hi,

I use Zabbix 6.2.6 with PostgreSQL with TimeScaleDB and today I tried to clear history on one item.
When I tried it I get this error:

Cannot clear history
History cleanup is not supported if compression is enabled [items.php:975 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod()

...

[John2wayne]

Hi I am facing a monitoring system project (zabbix), I would like to use a postgreSQL database with timescaleDB, will building the database from sources increase performance? Should I expect more problems after building from sources than by installing from package manager.

[stefek143]

Hello,
My version of Zabbix is 5.4,.I've made upgrade DB Postgres from 11 to 12 , next I wanted to update timescaledb from 1.7.4 to 2.1 but when I execute a command I get Error:



Do somebody know how to fix this problem?...

[jbdenis]

Hello,

I'm in the process to migrate to TimescaleDB and I'm wondering if using preprocessing discard step is still pertinent, from a storage usage and performance perspective considering the compression features of TimescaleDB. I found that using discard in a preprocessing step makes writing...

[kchojn]

Hello,
Has anyone had to experience the cloud TimescaleDb?

I will deploy Zabbix 6.0 LTS with postgres timescaledb but on virtual machine. I wonder if there will be any problems switching to the cloud version?

Best Regards,
Karol!