Postgresql Monitoring by Zabbix Agent2 Template for PostgreSQL16

[Min Tun]

Hi everyone,

I saw the official documentation of PostgreSQL by Zabbix Agent2 supports for Postgres Version 10-15. https://git.zabbix.com/projects/ZBX/...at=release/7.0
Is this template usable for PostgreSQL 16? If not support, how could I do for PostgreSQL16 monitoring?

[Min Tun]

Yes it works well with PostgreSQL16. I just updated the template from latest release of version 7.0-0

And here's the commands I run for PostgreSQL-Plugin installation and configuration.
-----------------
sudo apt update
sudo apt install golang
go version

tar xvf zabbix-agent2-plugin-postgresql-7.0.3.tar.gz
mv /home/appadm/zabbix-agent2-plugin-postgresql-7.0.3 /etc/zabbix/
cd /etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/
make
make check
ls
chmod 755 /etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/zabbix-agent2-plugin-postgresql
nano postgresql.conf
>> update postgresql.conf with following content
Plugins.PostgreSQL.System.Path=/etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/zabbix-agent2-plugin-postgresql

cp postgresql.conf /etc/zabbix/zabbix_agent2.d/
chmod 644 /etc/zabbix/zabbix_agent2.d/postgresql.conf

>>Includ the conf path in zabbix_agent2.conf (check the following line)
Include=/etc/zabbix/zabbix_agent2.d/*.conf

systemctl restart zabbix-agent2
tail -f /var/log/zabbix/zabbix_agent2.log
--------------

[cyber]

I doubt there is a big difference from monitoring perspective, is it 15 or 16... Andit is not said, it is supported on those versions, it says "has been tested on .. " Theres a difference..

[zabbixuser39393]

It works with psql 16 (well, at least with zabbix agent)

[Min Tun]

Yes it works well with PostgreSQL16. I just updated the template from latest release of version 7.0-0

And here's the commands I run for PostgreSQL-Plugin installation and configuration.
-----------------
sudo apt update
sudo apt install golang
go version

tar xvf zabbix-agent2-plugin-postgresql-7.0.3.tar.gz
mv /home/appadm/zabbix-agent2-plugin-postgresql-7.0.3 /etc/zabbix/
cd /etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/
make
make check
ls
chmod 755 /etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/zabbix-agent2-plugin-postgresql
nano postgresql.conf
>> update postgresql.conf with following content
Plugins.PostgreSQL.System.Path=/etc/zabbix/zabbix-agent2-plugin-postgresql-7.0.3/zabbix-agent2-plugin-postgresql

cp postgresql.conf /etc/zabbix/zabbix_agent2.d/
chmod 644 /etc/zabbix/zabbix_agent2.d/postgresql.conf

>>Includ the conf path in zabbix_agent2.conf (check the following line)
Include=/etc/zabbix/zabbix_agent2.d/*.conf

systemctl restart zabbix-agent2
tail -f /var/log/zabbix/zabbix_agent2.log
--------------