Hi,

I am trying to configure postgres monitoring for postgresql-14 database on ubuntu 20.04. Zabbix server and agents (v. 6.0.3) are also running on ubuntu 20.04. 

Firewall, db, zabbix config seems OK, yet I am getting unsupported item keys for all postgres related keys.

Here is output of zabbix_agentd (similar for zabbix_get on the server)

 zabbix_agentd -t "pgsql.config.hash["127.0.0.1","5432","zbx_monitor","zbx_monitor","postgres"]"
pgsql.config.hash[127.0.0.1,5432,zbx_monitor,zbx_monitor,postgres] [m|ZBX_NOTSUPPORTED] [Unsupported item key.]

Here is a section of the zabbix_server.log

11031:20220411:131038.618 item "dev-04:pgsql.replication.lag.b["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131039.619 item "dev-04:pgsql.bgwriter["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131040.620 item "dev-04:pgsql.connections["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131041.620 item "dev-04:pgsql.dbstat.sum["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131042.621 item "dev-04:pgsql.dbstat["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131043.622 item "dev-04:pgsql.locks["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131044.623 item "dev-04:pgsql.ping["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131045.624 item "dev-04:pgsql.replication.count["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131046.626 item "dev-04:pgsql.replication.lag.sec["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131047.627 item "dev-04:pgsql.replication.recovery_role["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131048.628 item "dev-04:pgsql.replication.status["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131049.631 item "dev-04:pgsql.uptime["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131050.632 item "dev-04:pgsql.autovacuum.count["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131051.632 item "dev-04:pgsql.archive["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11032:20220411:131052.635 item "dev-04:pgsql.wal.stat["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11033:20220411:131055.635 item "dev-04:pgsql.cache.hit["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Cannot evaluate function: not enough data at "last(//pgsql.dbstat.sum.blks_hit.rate) * 100 / (last(//pgsql.dbstat.sum.blks_hit.rate) + last(//pgsql.dbstat.sum.blks_read.rate))".
 11034:20220411:131056.636 item "dev-04:pgsql.oldest.xid["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11034:20220411:131056.640 item "dev-04:pgsql.replication.process["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}"]" became not supported: Unsupported item key.
 11031:20220411:131057.641 item "dev-04:pgsql.queries["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}","\{$PG.DATABASE}","\{$PG.QUERY_ETIME.MAX.WARN}"]" became not supported: Unsupported item key.

Looked on the web for 2 days for a solution, but I could not find anything relevant to my case.