TimescaleDB 2.4 / PostgreSQL 12 are not compressing or erasing old data.

[mbuyukkarakas]

Dear all

For the test purposes, I tried to install PGSQL 12 + Timescaledb 2.4. No problem during the setup. But after running zabbix services, I started to receive that kind of errors. And TimescaleDB is not compressing and erasing old data.

2021-10-24 21:56:33.975 EDT [16729]...

[rbenea]

Hello,

I tried installing a fresh Zabbix 5.2 with Pg12 and TimescaleDB on Debian 10. All is working fine, I can get a nice running Zabbix 5.2 serrver, then the problem is that if I enable TimescaleDB I get errors on zabbix_server.log:

[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:

...

[mturin]

Есть Zabbix-сервер, его база в MySQL занимает 250+Гб бинарных данных на диске. С некоторых пор стала медленновато ворочаться, хотя шардирование сделано.

Хотим перейти...

[doum]

Hi,

we currently use zabbix 4.4.10, with postgres 10.12 and timescaleDb

In the upgrade notes I read :
Enabling extended range of numeric (float) values
Numeric (float) data type now supports precision of approximately 15 digits and range from approximately -1.79E+308...

[doum]

Hi,

I have a problem with my zabbix database, growing without end.

I have, since begining (testing zabbix for two months now), configured zabbix with timescaledb
but I made a mistake with housekeeping parameter, keeping too much data, now my database size is more than...

[aDCoCa]

Hello everyone,

After executing:

"echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix" I receive: could not change directory to "/root": Permission denied WARNING: WELCOME TO _____ _ ...