search

lesovsky / zabbix-extensions

Zabbix additional monitoring modules
BSD 3-Clause "New" or "Revised" License
316 stars 230 forks source link

Template DB PostgreSQL: PostgreSQL: number of running processes postgres #70

Closed kunkanon closed 5 years ago

kunkanon commented 5 years ago

If you using a remote zabbix server to get information from postgreSQL process them can't retrive the data because it dont recover the prostgresql process, only from the zabbix user ( because it connect using the zabbix_agent to the remote server ).

[root@zabbix ~]# zabbix_get -s REMOTE_SERVER_IP -k proc.num[postgres] 0

kunkanon commented 5 years ago

The solution to this issue is change that trigger: {Template DB PostgreSQL:proc.num[{$PG_PROCESS_NAME}].last()}=0 To: {Template DB PostgreSQL:proc.num[,,,{$PG_PROCESS_NAME}|postmaster].last()}=0

Only works in zabbix 4.0+