-
Incident report
-
Resolution: Fixed
-
Trivial
-
None
-
4.2.6
-
GNU/Linux Debian 9 x64 + PostgreSQL 11 + Zabbix 4.2.6
Hello everyone, I'm monitoring a PostgreSQL11 database on Zabbix 4.2.6 with the following template (https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql), and everything works correctly, but in my control panel appears the following trigger:
"PostgreSQL: Streaming lag with {#MASTER} is too high (over 10m in 5m)"
This is the internal configuration of the template
- Name PostgreSQL: Streaming lag with {#MASTER} is too high (over {$PG.REPL_LAG.MAX.WARN} in 5m)
- Expression {Zabbix server:pgsql.replication.lag.sec["\{$PG.HOST}","\{$PG.PORT}","\{$PG.USER}","\{$PG.DB}"].min(5m)} > {$PG.REPL_LAG.MAX.WARN} {$PG.REPL_LAG.MAX.WARN}
And this is the configuration of the item where this trigger is activated
Name Replication: lag in seconds
Type Zabbix Agent
Key pgsql.replication.lag.sec["\{$PG.HOST}","\{$PG.PORT}","\{$PG.USER}","\{$PG.DB}"]
Host interface 127.0.0.1 10050
Type of information Numeric (float)
Units s
It's my only Zabbix server and we don't have replication activated with another server. What do you recommend me to do? Should I deactivate this trigger or should I correct something in the template or script that serves to monitor PostgreSQL?
Thank you.