Ukuseka ithemplate yePostgreSQL esemthethweni kwiZabbix 4.4

Molweni nonke.

UZabbix ngoku unegosa Isakhelo seDB PostgreSQL. Kweli nqaku siza kuyiqwalasela kwiZabbix 4.4.

QAPHELA

Ukuba ulungile ngesiNgesi, ke ndincoma ukuba ufake itemplate ngokwencwadi esemthethweni

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

Nangona kunjalo, inqaku lam lithathela ingqalelo ama-nuances angabandakanywanga kweli khonkco.

Ukulungiselela ithempleyithi

1. Yiya kuluhlu lwakho lwasekhaya.

cd ~

2. Khuphela usetyenziso lwe-git kwaye ulinganise indawo yokugcina ye-Zabbix esemthethweni, ebekwe kwi-GitHub.

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

3. Yiya kuluhlu ngePostgreSQL template.

cd zabbix/templates/db/postgresql/

Ukumisela itemplate ye-arhente ye-Zabbix

1. Masiqhagamshele kwiPostgreSQL.

psql -U postgres

2. Yenza umsebenzisi wokufunda kuphela zbx_monitor ngokufikelela kwiseva yePostgreSQL.

Kwinguqulo ye-PostgreSQL ye-10 nangaphezulu:

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

Kwinguqulo ye-PostgreSQL 9.6 nangaphantsi:

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

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

3. Khuphela i-postgresql/ ulawulo kwi/var/lib/zabbix/ directory. Ukuba awunayo i zabbix/ ulawulo kwi/var/lib/, yenze ke. I-postgresql / ulawulo luqulethe iifayile ezifunekayo ukufumana i-metrics kwi-PostgreSQL.

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

4. Emva koko kopisha ifayile ye-template_db_postgresql.conf kwi-agent ye-Zabbix yoqwalaselo lwefayile /etc/zabbix/zabbix_agentd.d/ kwaye uqale kwakhona i-agent ye-Zabbix.

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

5. Ngoku makhe sihlele ifayile pg_hba.conf ukuvumela uxhulumaniso kwi Zabbix. Iinkcukacha ezingakumbi malunga nefayile ye-pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Vula ifayile:

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

Yongeza omnye wemigca (Ukuba awuqondi ukuba kutheni oku kufuneka, ngoko yongeza kuphela umgca wokuqala.):

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

QAPHELA

Ukuba i-PostgreSQL ifakwe ukusuka kwindawo yokugcina ye-PGDG, yongeza indlela eya ku-pg_isready ku-PATH oguquguqukayo wemekobume kumsebenzisi we-zabbix.

Njengenketho:

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

* - kuba ndine pgsql version 12, uya kuba nendlela eyahlukileyo endaweni pgsql-12.

Ukuba oku ayenziwanga, ngoko iSimo: i-Ping iyakuhlala iPhantsi.

Ukongeza itemplate kwi-frontend ye-Zabbix

Ndiyakholelwa ukuba abo bafuna ukuthatha i-metrics kwi-PostgreSQL sele beyazi indlela yokongeza iitemplates. Ngoko ke, ndiya kuchaza inkqubo ngokufutshane.

1. Yiya kwiphepha leZabbix;
2. Yiya kwiphepha "uqwalaselo=> "host";
3. Cofa kwiqhosha "Yenza umamkeli"okanye khetha umamkeli okhoyo;
4. Kwiphepha lokudala/lokuhlela, khetha i “itemplates"kwaye kwaye ucofe ikhonkco"Yongeza";
5. Ku "Iqela", khetha "Iitemplates / iiDatabases" kuluhlu, khetha itemplate "Isakhelo seDB PostgreSQL", cofa iqhosha"khetha"kwaye ucofe iqhosha"Gqiba";

Silinde ixesha kwaye ekugqibeleni siye ku "esweni=> "Idatha yamva nje=> "Amakhaya"khetha iseva ngePostgreSQL => cofa"Faka«.

Konwabele!

umthombo: www.habr.com