[ZBX-22583] Agent2 [PostgreSQL] Cannot fetch data: query "all_tables_stat" not found. Created: 2023 Mar 24  Updated: 2023 Mar 27  Resolved: 2023 Mar 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Templates (T)
Affects Version/s: 6.0.14
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Arkadiy Assignee: Zabbix Integration Team
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2023-03-24-13-35-39-024.png     PNG File image-2023-03-24-13-37-15-257.png     PNG File image-2023-03-24-13-38-42-628.png    

 Description   

PostgreSQL template works fine.

Steps to reproduce:

Item key in template

pgsql.custom.query["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}","\{$PG.DATABASE}","all_tables_stat"]


 
/etc/zabbix/zabbix_agent2.conf

 
Custom script permissions and location

 
/var/log/zabbix/zabbix_agent2.log
[PostgreSQL] Cannot fetch data: query "all_tables_stat" not found.

 Comments   
Comment by Arkadiy [ 2023 Mar 27 ]

I have solved this by addding Plugins.Postgres.CustomQueriesPath value into postgres plugin config.

Generated at Wed May 07 07:00:43 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.