Monitoring PostgreSQL using Zabbix

Daria Vilkova's presentation for Zabbix Meetup Online

I want to introduce you to the PostgreSQL and operating system monitoring tool, which is being developed by our company using Zabbix.

Zabbix , , , .

— Mamonsu, , , Zabbix Server. Mamonsu .

Mamonsu

Mamonsu — (Zabbix Trapper) PostgreSQL . Mamonsu ( Python) PostgreSQL .

Mamonsu :

• mamonsu tune — , PostgreSQL Mamonsu.
• mamonsu report — , PostgreSQL.

Mamonsu , , JSON, Zabbix Server, .

Mamonsu

Mamonsu

• PostgreSQL. PostgreSQL — Mamonsu. , .
• . Mamonsu «» , , Python, , . . .
• PostgreSQL .
• , « ».
• , Zabbix Server.
• , , Linux, .
• BSD-clause license.

- .

• 14 PostgreSQL,
• 8 OS Linux,
• 4 OS Windows.

Mamonsu 110 PostgreSQL :

• 70 PostgreSQL,
• 40 OS Linux,
• 8 OS Windows.

, , , , /, , WAL. , GitHub.

GitHub

Mamonsu 5

PostgreSQL Mamonsu 5 , 5 .

1. Mamonsu. Mamonsu .

$ git clone ... && cd mamonsu && python setup.py

build && python setup.py install

1. . c PostgreSQL Zabbix Server agent.conf.

/etc/mamonsu/agent.conf

1. Zabbix Server.

$ mamonsu zabbix template export

/usr/share/mamonsu/example.xml

1. Zabbix Server. Zabbix Server.

$ mamonsu zabbix host create mamonsu-demo

1. .

$ service mamonsu start

Mamonsu

Mamonsu , . , mamonsu tune.

PostgreSQL Zabbix Agent 2

PostgreSQL pgx (PG driver and toolkit for Go).

: Exporter, , Configurator Zabbix Agent 2, , .

, (handler) , JSON (dependency items), (discovery rules).

• PostgreSQL ;
• ;
• PostgreSQL, 10, Zabbix Server, 4.4;
• PostgreSQL , Zabbix Agent 2 .

PostgreSQL

PostgreSQL, . . :

• Global,
• Sessions,
• Macros.

1. Global , Session Macros .

   
   
   

2. PostgreSQL — Sessions zabbix_agent2.conf.

   
   
   

PostgreSQL — Sessions

• Sessions , ().
• URI UserName .
• , PostgreSQL, .

1. PostgreSQL — Macros ( , Zabbix Agent 1), . . . , . ., , URI .

PostgreSQL — Macros

PostgreSQL 95 , PostgreSQL, :

• ,
• ,
• wal-,
• ,
• «» ,
• ,
• .

PostgreSQL . Zabbix Agent 2 , .

(handler)

(handler) — , .

:

1. :

zabbix/src/go/plugins/postgres/handler_uptime.go

1. () :

1. (handler) , . . , :

1. :

, Zabbix Agent 2.

1. :

.

, Zabbix 5.0 https://www.zabbix.com/download. Zabbix host port. Zabbix 5.0.2, , URI.

!

GitHub Mamonsu

Mamonsu

Zabbix Git