PostgreSQL plugin ping not working

[lpossamai]

Hello,

I have a cluster of PostgreSQL 9.2 databases, therefore I need to use the old plugin, and have setup monitoring with Zabbix and the PostgreSQL plugin. I'm monitoring 3 servers and for two of them, the

pgsql.ping

object is not working.


Zabbix Server error log shows the following:

69450:20210602:074613.276 Sending [[B]pgsql.ping[/B]["pgsql-database-02.example.com","5432","zbx_monitor","databasename"]]

69450:20210602:074616.277 Item [pgsql-database-02.example.com:[B]pgsql.ping[/B]["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.D B}"]] error: Timeout while executing a shell script.

69444:20210602:074616.395 zbx_substitute_functions_results() expression[4]:'{23481} = 0' => 'ERROR(Cannot evaluate function last(/pgsql-database-02.example.com/[B]pgsql.ping[/B]["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.D B}"]): item is not supported.) = 0'

69444:20210602:074616.396 evaluate_expressions():expression [{23481} = 0] cannot be evaluated: Cannot evaluate function last(/pgsql-database-02.example.com/[B]pgsql.ping[/B]["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.D B}"]): item is not supported.

What can I do to troubleshoot this? Also, is there a way of running

last(/pgsql-database-02.example.com/[B]pgsql.ping[/B]["{$PG.HOST}","{$PG.PORT}","{$PG.USER}","{$PG.D B}"])

from the server being monitored itself? or from the zabbix server?

Thanks in advance!