[ZBX-21886] Missing PostgreSQL plugin in Zabbix agent 2 6.0.10 Created: 2022 Nov 07  Updated: 2025 Jan 28  Resolved: 2023 Jul 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent2 plugin (G)
Affects Version/s: 6.0.10
Fix Version/s: 6.0.20rc1, 6.4.5rc1, 7.0.0alpha3, 7.0 (plan)

Type: Problem report Priority: Trivial
Reporter: Peter Assignee: Jurijs Klopovskis
Resolution: Fixed Votes: 8
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Windows 32/64, RHEL 8


Attachments: File zabbix_agent2_plugins-6.0.19-windows-amd64.msi     Zip Archive zabbix_agent2_plugins-6.0.19-windows-amd64.zip     File zabbix_agent2_plugins-6.0.19-windows-i386.msi     Zip Archive zabbix_agent2_plugins-6.0.19-windows-i386.zip     File zabbix_agent2_plugins-6.4.4-windows-amd64.msi     Zip Archive zabbix_agent2_plugins-6.4.4-windows-amd64.zip     File zabbix_agent2_plugins-6.4.4-windows-i386.msi     Zip Archive zabbix_agent2_plugins-6.4.4-windows-i386.zip     Text File zlog.txt    
Issue Links:
Duplicate
is duplicated by ZBX-21894 PostgreSQL by Zabbix agent 2 totally ... Closed
Sub-task
Team: Team B
Sprint: Sprint 94 (Nov 2022), Sprint 95 (Dec 2022), Sprint 96 (Jan 2023), Sprint 97 (Feb 2023), Sprint 98 (Mar 2023), Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023), Sprint 102 (Jul 2023)
Story Points: 4

 Description   

Steps to reproduce:

  1. Download & install Zabbix Agent2 version 6.0.10 (e.g. Windows or RHEL build)
  2. Start the agent & examine zabbix agent log
  3. The postgre sql plugin is not present

Result:
See attached log file.
Expected:

Present postgre sql plugin.



 Comments   
Comment by Jurijs Klopovskis [ 2022 Nov 08 ]

It has been moved into a standalone plugin.

On RHEL install zabbix-agent2-plugin-postgresql

On windows for now it's only available from sources https://cdn.zabbix.com/zabbix-agent2-plugins/sources/postgresql/zabbix-agent2-plugin-postgresql-1.2.0.tar.gz

Comment by Ivan Zubov [ 2022 Nov 09 ]

Should i do anything else to link this plugin into agent? 

I installed zabbix-agent2-plugin-postgresql but it not listed at plugins after restart agent.

My log:
cat /var/log/zabbix/zabbix_agent2.log
2022/11/09 22:29:32.504228 Starting Zabbix Agent 2 (6.0.10)
2022/11/09 22:29:32.504583 OpenSSL library (OpenSSL 1.1.1f  31 Mar 2020) initialized
2022/11/09 22:29:32.505196 using configuration file: /etc/zabbix/zabbix_agent2.conf
2022/11/09 22:29:32.505251 using plugin 'Agent' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505256 using plugin 'Ceph' (built-in) providing following interfaces: exporter, runner, configurator
2022/11/09 22:29:32.505263 using plugin 'Cpu' (built-in) providing following interfaces: exporter, collector, runner
2022/11/09 22:29:32.505270 using plugin 'DNS' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505276 using plugin 'Docker' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505283 using plugin 'File' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505297 using plugin 'Hw' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505303 using plugin 'Kernel' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505307 using plugin 'Log' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505310 using plugin 'MQTT' (built-in) providing following interfaces: watcher, configurator
2022/11/09 22:29:32.505314 using plugin 'Memcached' (built-in) providing following interfaces: exporter, runner, configurator
2022/11/09 22:29:32.505318 using plugin 'Memory' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505339 using plugin 'Modbus' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505347 using plugin 'Mysql' (built-in) providing following interfaces: exporter, runner, configurator
2022/11/09 22:29:32.505360 using plugin 'NetIf' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505364 using plugin 'Oracle' (built-in) providing following interfaces: exporter, runner, configurator
2022/11/09 22:29:32.505370 using plugin 'Proc' (built-in) providing following interfaces: exporter, collector
2022/11/09 22:29:32.505373 using plugin 'ProcExporter' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505376 using plugin 'Redis' (built-in) providing following interfaces: exporter, runner, configurator
2022/11/09 22:29:32.505380 using plugin 'Smart' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505384 using plugin 'Sw' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505388 using plugin 'Swap' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505391 using plugin 'SystemRun' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505395 using plugin 'Systemd' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505400 using plugin 'TCP' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505412 using plugin 'UDP' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505417 using plugin 'Uname' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505421 using plugin 'Uptime' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505425 using plugin 'Users' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505428 using plugin 'VFSDev' (built-in) providing following interfaces: exporter, collector
2022/11/09 22:29:32.505432 using plugin 'VFSDir' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505435 using plugin 'VfsFs' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505439 using plugin 'WebCertificate' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505444 using plugin 'WebPage' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505447 using plugin 'ZabbixAsync' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505451 using plugin 'ZabbixStats' (built-in) providing following interfaces: exporter, configurator
2022/11/09 22:29:32.505520 lowering the plugin ZabbixSync capacity to 1 as the configured capacity 100 exceeds limits
2022/11/09 22:29:32.505524 using plugin 'ZabbixSync' (built-in) providing following interfaces: exporter
2022/11/09 22:29:32.505611 Plugin support version 1.1
2022/11/09 22:29:32.505649 Zabbix Agent2 hostname: [hostname]

Comment by Jurijs Klopovskis [ 2022 Nov 09 ]

Should i do anything else to link this plugin into agent? 

Did you install from packages? There it must work out of box.

Or did you build from source? Then the plugin conf file must loaded by agent2.
Plugin comes with a *.conf file.

  1. Inside you must specify the full path to the plugin binary.
  2. Put the plugin conf file where agent2 is looking for includes (See agent2 conf file).

That should be it.

Comment by David Zumbrunnen [ 2022 Nov 15 ]

After updating to 6.0.10 (on Ubuntu), we're facing the same issues as described here and in ZBX-21894: PostgreSQL monitoring stopped working ("Unknown metric pgsql.*"). And on top, the all of a sudden "loadable plugin" is missing in the Ubuntu packages: It's not included in "zabbix-agent2" and there is no "zabbix-agent2-plugin-postgresql" package in the official Zabbix repo.

IMHO that change (previously built-in plugin becoming a "loadable" one - but not being shipped) was a bit too much of a breaking change for a patch version....

Comment by Jurijs Klopovskis [ 2022 Nov 16 ]

After updating to 6.0.10 (on Ubuntu), we're facing the same issues as described here

Follow changes in https://support.zabbix.com/browse/ZBX-21855?focusedCommentId=733548&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-733548 regarding packages, david.zumbrunnen.
A fix has been released there.

This issue pertains specifically to windows.

Comment by Przemyslaw Jagielski [ 2023 Mar 13 ]

Zabbix-agent 6.2.5 on Windows Server have the same problem. 

Comment by Jurijs Klopovskis [ 2023 Jul 06 ]

We haven't set up regular builds of plugins for windows during regular release procedure yet, but here are latest builds to try out.

Generated at Sat Apr 19 03:21:45 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.