pgsql.db.discovery' error: the only supported schemes are: tcp and unix

[ascholdan]

Hello

i've got this error using postgres monitoring for agent2 i tried already changing {$PG.URI} to tcp://localhost:5432

2020/08/18 10:56:06.381394 received passive check request: 'pgsql.db.discovery' from '10.253.128.162'
2020/08/18 10:56:06.381478 [1] processing update request (1 requests)
2020/08/18 10:56:06.381493 [1] adding new request for key: 'pgsql.db.discovery'
2020/08/18 10:56:06.381510 [1] created direct exporter task for plugin 'Postgres' itemid:0 key 'pgsql.db.discovery'
2020/08/18 10:56:06.381578 executing direct exporter task for key 'pgsql.db.discovery'
2020/08/18 10:56:06.381595 failed to execute direct exporter task for key 'pgsql.db.discovery' error: 'the only supported schemes are: tcp and unix'
2020/08/18 10:56:06.381622 sending passive check response: ZBX_NOTSUPPORTED: 'the only supported schemes are: tcp and unix' to '10.253.128.162'

[EuGenE_New1]

I have same issue. The template for zabbix_agent2 just does not work. Did anyone resolved it?

[Atsushi]

How do you set the macro "{$PG.URI}" in the template "Template DB PostgreSQL Agent 2" or host?

[ascholdan]

I got a support agreement with zabbix now, but remove the template and download the latest from zabbix instead solved the issue

[EuGenE_New1]

How do you set the macro "{$PG.URI}" in the template "Template DB PostgreSQL Agent 2" or host?

Default was postgresql://localhost:5432, changed to tcp://localhost:5432 with no success

I got a support agreement with zabbix now, but remove the template and download the latest from zabbix instead solved the issue

Thanks, I will try that