monitoring postgress 12 on ubuntu

[ilia]

I want to monitor A PostgreSQLDB

I have an ubuntu (lxc based) system with postgress12 i would like to monitor

i tried different solution's i found online, but none worked..
can anyone suggest a step by step solution that works?



Thanks

[AVP.Riga]

Hi,

This one works perfectly but it's for CentOS, but I don't see any promlem to change dnf to apt-get and change repo links from rhel/centos to ubuntu.

https://bestmonitoringtools.com/how-to-install-zabbix-server-on-centos-or-rhel/

Also I see there is article version for debian: https://bestmonitoringtools.com/how-...ver-on-debian/

[AVP.Riga]

Part with postgress12 timescaledb you can find there:
https://techexpert.tips/zabbix/zabbi...-ubuntu-linux/
I assume you want install with postgress because you want to use timescaledb extension?

[ilia]

i think i was not clear enough ( i just updated my original question )
i already have a zabbix server 5.2.1 that monitor around 50 various hosts, no i want to monitor a specific PostgreSQL sql DB

[AVP.Riga]

Hello,

It's not very tricky. You can use built-in template:

https://www.zabbix.com/integrations/postgresql

Also you can use agent-less check by ssh commands.
Like: [root@centos8min2 ~]# systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2020-11-17 09:54:36 EET; 5h 49min ago
After it you can use preprocessing to clean everything except: active (running) or inactive (dead), after it use Value Mapping to convenient it to more convenient look.

[ilia]

Hello,

It's not very tricky. You can use built-in template:

https://www.zabbix.com/integrations/postgresql

Also you can use agent-less check by ssh commands.
Like: [root@centos8min2 ~]# systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2020-11-17 09:54:36 EET; 5h 49min ago
After it you can use preprocessing to clean everything except: active (running) or inactive (dead), after it use Value Mapping to convenient it to more convenient look.

but the template there is yml and not xml,

[AVP.Riga]

Templates already inside:
Also you can try to use Postrgresql Prometheus exporter with https://www.zabbix.com/integrations/prometheus

[ilia]

i found the template and imported it,
but when all the items->test return

• Unsupported item key.