Checklist de 25 pontos para avaliar a maturidade de uma operação Zabbix

[cleberfelix]

Pessoal, compartilho um checklist que venho usando em assessment de ambiente. Talvez seja útil para quem herdou um Zabbix mal configurado ou está preparando uma evolução de versão.

São 25 verificações em cinco áreas. A ideia não é contar quantos "sim" você tem —...

[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...