Ukusetha ithempulethi esemthethweni ye-PostgreSQL ku-Zabbix 4.4

Sanibonani nonke.

Manje uZabbix unesikhulu Isifanekiso se-DB PostgreSQL. Kulesi sihloko sizoyilungisa ku-Zabbix 4.4.

QAPHELA

Uma usazi kahle isiNgisi, ngincoma ukuthi ufake ithempulethi ngokuya ngebhukwana elisemthethweni

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

Kodwa-ke, i-athikili yami ibheka ama-nuances angafakiwe kulesi sixhumanisi.

Ilungiselela isifanekiso

1. Yiya ohlwini lwemibhalo lwasekhaya.

cd ~

2. Landa insiza ye-git bese ufanisa inqolobane esemthethweni ye-Zabbix, etholakala ku-GitHub.

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

3. Iya kuhla lwemibhalo ngesifanekiso se-PostgreSQL.

cd zabbix/templates/db/postgresql/

Isetha isifanekiso somenzeli we-Zabbix

1. Masixhume ku-PostgreSQL.

psql -U postgres

2. Dala i-zbx_monitor yomsebenzisi wokufunda kuphela onokufinyelela kuseva ye-PostgreSQL.

Ngenguqulo 10 ye-PostgreSQL nangaphezulu:

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

Ngenguqulo ye-PostgreSQL engu-9.6 nangezansi:

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

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

3. Kopisha i-postgresql/ directory ohlwini lwemibhalo /var/lib/zabbix/. Uma ungenayo i-zabbix/ inkomba ku-/var/lib/, bese uyidala. I-postgresql/inkomba iqukethe amafayela adingekayo ukuze kutholwe amamethrikhi ku-PostgreSQL.

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

4. Yibe usukopisha ifayela le-template_db_postgresql.conf kumkhombandlela wokumisa umenzeli we-Zabbix /etc/zabbix/zabbix_agentd.d/ bese uqala kabusha i-ejenti ye-Zabbix.

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

5. Manje ake sihlele ifayela elithi pg_hba.conf ukuze sivumele ukuxhuma ku-Zabbix. Imininingwane eyengeziwe mayelana nefayela elithi pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Vula ifayela:

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

Engeza umugqa owodwa (Uma ungaqondi ukuthi kungani lokhu kudingeka, bese wengeza umugqa wokuqala kuphela.):

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

Uma i-PostgreSQL ifakiwe isuka endaweni ye-PGDG, engeza indlela eya ku-pg_isready ekuguquguqukeni kwemvelo kwe-PATH kumsebenzisi we-zabbix.

Njengenketho:

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

* - njengoba nginenguqulo ye-pgsql engu-12, uzoba nendlela ehlukile esikhundleni se-pgsql-12.

Uma lokhu kungenziwanga, isimo: I-Ping izohlala iphansi.

Ukwengeza isifanekiso ngaphambili kwe-Zabbix

Ngikholwa ukuthi labo abadinga ukuthatha amamethrikhi ku-PostgreSQL sebeyazi ukuthi bangeza kanjani izifanekiso. Ngakho-ke, ngizochaza inqubo kafushane.

1. Iya ekhasini elithi Zabbix;
2. Iya ekhasini "Ukucushwa=> "Host";
3. Chofoza inkinobho "Dala umsingathi"noma khetha umsingathi okhona;
4. Ekhasini lokudala/lokuhlela lomsingathi, khetha okuthi “Izibonisi"bese uchofoza kusixhumanisi"Engeza";
5. Ku-"Iqembu", khetha "Izifanekiso/Imininingwane Yolwazi" ohlwini, khetha isifanekiso esithi “Isifanekiso se-DB PostgreSQL", cindezela inkinobho"Khetha"bese ucindezela inkinobho"Update";

Silinde isikhathi futhi ekugcineni siye ku-“Ukuqapha=> "Idatha yakamuva=> "Amahostela"khetha iseva nge-PostgreSQL => chofoza"Faka isicelo".

Jabulela!

Source: www.habr.com