Ịtọlite ​​​​nhazi akwụkwọ PostgreSQL na Zabbix 4.4

Ndewonu onye obula.

Zabbix nwere onye ọrụ ugbu a Ụdị DB PostgreSQL. N'isiokwu a, anyị ga-ahazi ya na Zabbix 4.4.

MARA

Ọ bụrụ na ị dị mma na Bekee, m na-akwado ịwụnye template dị ka akwụkwọ ntuziaka

github.com/zabbix/zabbix/tree/master/templates/db/postgresql

Agbanyeghị, akụkọ m na-eburu n'uche nuances na-esonyeghị na njikọ a.

Na-akwado template

1. Gaa na ndekọ ụlọ.

cd ~

2. Budata git utility wee mechie ebe nchekwa Zabbix gọọmentị, nke dị na GitHub.

yum -y install git
git clone https://github.com/zabbix/zabbix.git

3. Gaa na ndekọ na ndebiri PostgreSQL.

cd zabbix/templates/db/postgresql/

Ịtọlite ​​​​ndebiri maka onye nnọchi anya Zabbix

1. Ka anyị jikọọ na PostgreSQL.

psql -U postgres

2. Mepụta onye ọrụ na-agụ naanị zbx_monitor iji nweta ihe nkesa PostgreSQL.

Maka ụdị PostgreSQL 10 na karịa:

CREATE USER zbx_monitor WITH PASSWORD '<ВАШ_ПАРОЛЬ>' INHERIT; GRANT pg_monitor TO zbx_monitor;

Maka ụdị PostgreSQL 9.6 na n'okpuru:

CREATE USER zbx_monitor WITH PASSWORD '<ВАШ_ПАРОЛЬ>';
GRANT SELECT ON pg_stat_database TO zbx_monitor;

--Для сбора метрик WAL пользователь должен быть superuser.
ALTER USER zbx_monitor WITH SUPERUSER;

3. Detuo postgresql/ ndekọ na /var/lib/zabbix/ directory. Ọ bụrụ na ịnweghị zabbix/ ndekọ na /var/lib/, mepụta ya. Akwụkwọ ndekọ aha postgresql nwere faịlụ ndị achọrọ iji weghachite metrik na PostgreSQL.

cp -r postgresql/ /var/lib/zabbix/

4. Mgbe ahụ, detuo template_db_postgresql.conf faịlụ na Zabbix nnọchiteanya nhazi directory /etc/zabbix/zabbix_agentd.d/ na Malitegharịa ekwentị Zabbix gị n'ụlọnga.

cp template_db_postgresql.conf /etc/zabbix/zabbix_agentd.d/

5. Ugbu a, ka dezie pg_hba.conf faịlụ ekwe ka njikọ Zabbix. Nkọwa ndị ọzọ gbasara faịlụ pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Mepee faịlụ:

vi /var/lib/pgsql/12/data/pg_hba.conf

Tinye otu ahịrị (Ọ bụrụ na ị ghọtaghị ihe kpatara nke a, tinyezie naanị ahịrị mbụ.):

host all zbx_monitor 127.0.0.1/32 trust
host all zbx_monitor 0.0.0.0/0 md5
host all zbx_monitor ::0/0 md5

MARA

Ọ bụrụ na etinyere PostgreSQL site na ebe nchekwa PGDG, tinye ụzọ na pg_isready na mgbanwe gburugburu PATH maka onye ọrụ zabbix.

Dị ka nhọrọ:

ln -s /usr/pgsql-12/bin/pg_isready /usr/bin/pg_isready

* - ebe m nwere ụdị pgsql 12, ị ga-enwe ụzọ dị iche karịa pgsql-12.

Ọ bụrụ na emeghị nke a, mgbe ahụ Ọnọdụ: Ping ga-adị ala mgbe niile.

Na-agbakwụnye template na Zabbix frontend

Ekwenyere m na ndị kwesịrị ịnara metrics site na PostgreSQL amatalarị ka esi etinye ndebiri. Ya mere, m ga-akọwa usoro nkenke.

1. Gaa na ibe Zabbix;
2. Gaa na ibe "nhazi" =>"Onye ọbịa";
3. Pịa na bọtịnụ"Mepụta onye ọbịa"ma ọ bụ họrọ onye ọbịa dị adị;
4. Na peeji nke imepụta/edezi, họrọ “Templates"ma pịa njikọ ahụ"tinye";
5. Na "Group", họrọ "Templates/Databases" na listi ahụ, họrọ template "Ụdị DB PostgreSQL", pịa bọtịnụ"họrọ"ma pịa bọtịnụ"update";

Anyị chere ruo oge ụfọdụ, n'ikpeazụ wee gaa "Monitoring" =>"Data kacha ọhụrụ" =>"Ndị ọbịa"họrọ ihe nkesa nwere PostgreSQL => pịa"Tee".

-Enwe!

isi: www.habr.com