Hi Forum,
I´m working on an integration to a Postgres server/database, integration itself is fine so far. But we´ve recognized that the connections reported in zabbix are just wrong from my point of view.
In Zabbix itself we are 16 connections (total) reported (see image below):
However when checking with pgAdmin tool, I query for the connections as well. By the way the query is from source code in github here: https://github.com/zabbix/zabbix/blo...ctions.sum.sql
and from my point the queryy works totally fine. Please note I added line 5 and 8 in the screenshot below to make the issue more clear.
So bottom line Zabbix is reporting 16 total connections, okay. But in fact Zabbix is only reporting it´s OWN connections and not the total connections of the server. This makes the total % value also wrong (8% vs. in reality 27%) and therefore required alarms will not be reported.
My setup is:
- Zabbix Server 7.2.0
- Zabbix Agent2 - latest
with the "PostgreSQL by Zabbix agent 2 active" template. I also tried the non-active template.. its the same issue.
Any feedback / help is high likely welcome.
Thanks
Torsten
I´m working on an integration to a Postgres server/database, integration itself is fine so far. But we´ve recognized that the connections reported in zabbix are just wrong from my point of view.
In Zabbix itself we are 16 connections (total) reported (see image below):
However when checking with pgAdmin tool, I query for the connections as well. By the way the query is from source code in github here: https://github.com/zabbix/zabbix/blo...ctions.sum.sql
and from my point the queryy works totally fine. Please note I added line 5 and 8 in the screenshot below to make the issue more clear.
So bottom line Zabbix is reporting 16 total connections, okay. But in fact Zabbix is only reporting it´s OWN connections and not the total connections of the server. This makes the total % value also wrong (8% vs. in reality 27%) and therefore required alarms will not be reported.
My setup is:
- Zabbix Server 7.2.0
- Zabbix Agent2 - latest
with the "PostgreSQL by Zabbix agent 2 active" template. I also tried the non-active template.. its the same issue.
Any feedback / help is high likely welcome.
Thanks
Torsten