Kukhazikitsa template yovomerezeka ya PostgreSQL pa Zabbix 4.4

Moni nonse.

Zabbix tsopano ali ndi mkulu Tsamba la DB PostgreSQL. M'nkhaniyi tikonza mu Zabbix 4.4.

Zindikirani

Ngati muli bwino ndi Chingerezi, ndiye ndikupangira kukhazikitsa template malinga ndi buku lovomerezeka

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

Komabe, nkhani yanga imaganizira ma nuances omwe sanaphatikizidwe mu ulalo uwu.

Kukonzekera template

1. Pitani ku chikwatu chakunyumba kwanu.

cd ~

2. Tsitsani ntchito ya git ndikufanizira malo ovomerezeka a Zabbix, omwe ali pa GitHub.

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

3. Pitani ku chikwatu ndi template ya PostgreSQL.

cd zabbix/templates/db/postgresql/

Kukhazikitsa template ya wothandizira Zabbix

1. Tiyeni tigwirizane ndi PostgreSQL.

psql -U postgres

2. Pangani wowerenga wowerenga zbx_monitor ndi mwayi wofikira seva ya PostgreSQL.

Kwa PostgreSQL mtundu 10 ndi apamwamba:

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

Kwa mtundu wa PostgreSQL 9.6 ndi pansipa:

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

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

3. Lembani postgresql/ chikwatu ku /var/lib/zabbix/ directory. Ngati mulibe zabbix/ directory mu /var/lib/, pangani. The postgresql / directory ili ndi mafayilo ofunikira kuti mutengenso ma metrics kuchokera ku PostgreSQL.

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

4. Kenako lembani fayilo ya template_db_postgresql.conf ku Zabbix agent configuration directory /etc/zabbix/zabbix_agentd.d/ ndikuyambitsanso wothandizira Zabbix.

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

5. Tsopano tiyeni tisinthe pg_hba.conf wapamwamba kuti tilole kulumikizana ndi Zabbix. Zambiri za fayilo ya pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Tsegulani fayilo:

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

Onjezani umodzi mwa mizere (Ngati simukumvetsa chifukwa chake izi zikufunika, onjezerani mzere woyamba wokha.):

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

Zindikirani

Ngati PostgreSQL yakhazikitsidwa kuchokera ku PGDG repository, onjezani njira yopita ku pg_isready ku PATH chilengedwe variable kwa wosuta zabbix.

Monga njira:

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

* - popeza ndili ndi pgsql version 12, mudzakhala ndi njira ina m'malo mwa pgsql-12.

Ngati izi sizinachitike, ndiye kuti Status: Ping idzakhala Pansi nthawi zonse.

Kuwonjezera template pa Zabbix frontend

Ndikukhulupirira kuti iwo omwe akufunika kutenga ma metrics kuchokera ku PostgreSQL amadziwa kale kuwonjezera ma templates. Choncho, ndikufotokozera ndondomekoyi mwachidule.

1. Pitani ku tsamba la Zabbix;
2. Pitani ku tsamba "kasinthidwe=> "khamu";
3. Dinani pa batani "Pangani wolandira"kapena sankhani gulu lomwe lilipo;
4. Patsamba lokonzekera / lokonzekera, sankhani "Zithunzi"ndipo dinani ulalo"kuwonjezera";
5. Mu "Gulu", sankhani "Ma templates/Databas" pamndandanda, sankhani "Tsamba la DB PostgreSQL", dinani batani "Sankhani"ndipo dinani batani"Pezani";

Timadikirira kwakanthawi ndipo pamapeto pake timapita "Kuwunika=> "Zambiri zaposachedwa=> "Othandiza"sankhani seva ndi PostgreSQL => dinani"Ikani".

Sangalalani!

Source: www.habr.com