Te whakatu i te tauira PostgreSQL whaimana i runga i te Zabbix 4.4

Aroha katoa.

Kua whai mana a Zabbix inaianei Tauira DB PostgreSQL. I roto i tenei tuhinga ka whirihorahia e matou i roto i te Zabbix 4.4.

FAKATOKANGA

Mena he pai koe ki te reo Ingarihi, ka tūtohu ahau ki te whakauru i te tauira kia rite ki te pukapuka mana

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

Heoi, ka whakaarohia e taku tuhinga nga ahuatanga kaore i whakauruhia ki tenei hononga.

Te whakarite i te tauira

1. Haere ki to whaiaronga kainga.

cd ~

2. Tikiake i te whaipainga git ka kati i te putunga whai mana a Zabbix, kei runga i GitHub.

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

3. Haere ki te whaiaronga me te tauira PostgreSQL.

cd zabbix/templates/db/postgresql/

Te whakarite tauira mo te kaihoko Zabbix

1. Me hono tatou ki PostgreSQL.

psql -U postgres

2. Waihangatia he kaiwhakamahi panui-anake zbx_monitor me te uru ki te tūmau PostgreSQL.

Mo te putanga PostgreSQL 10 me te teitei ake:

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

Mo te putanga PostgreSQL 9.6 me raro:

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

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

3. Tāruahia te whaiaronga postgresql/ ki te whaiaronga /var/lib/zabbix/. Mena karekau he zabbix/ whaiaronga kei /var/lib/, katahi ka hanga. Kei roto i te postgresql / whaiaronga nga konae hei tiki i nga inenga mai i te PostgreSQL.

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

4. Na ka kape i te kōnae template_db_postgresql.conf ki te whaiaronga whirihoranga kaihoko Zabbix /etc/zabbix/zabbix_agentd.d/ ka timata ano i te kaihoko Zabbix.

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

5. Inaianei me whakatika te pg_hba.conf konae hei tuku hononga ki a Zabbix. Ētahi atu kōrero mō te kōnae pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Whakatuwheratia te kōnae:

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

Taapirihia tetahi o nga rarangi (Ki te kore koe e mohio he aha te take e hiahiatia ana, katahi ko te rarangi tuatahi anake.):

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

FAKATOKANGA

Mena kua whakauruhia a PostgreSQL mai i te putunga PGDG, taapirihia te ara ki te pg_isready ki te taurangi taiao PATH mo te kaiwhakamahi zabbix.

Hei kōwhiringa:

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

* - i te mea kei a au te pgsql putanga 12, ka rere ke to huarahi hei utu mo te pgsql-12.

Ki te kore e mahia, ka noho tonu te Tūnga: Ping ki raro.

Te taapiri i tetahi tauira ki te taha o mua o Zabbix

E whakapono ana ahau ko te hunga e hiahia ana ki te tango i nga inenga mai i te PostgreSQL kua mohio ki te taapiri tauira. Na reira, ka whakaahua poto ahau i te tukanga.

1. Haere ki te wharangi Zabbix;
2. Haere ki te wharangi "whirihoranga" => "Kaihautū";
3. Paatohia te paatene "Waihanga kaihautu"whiria ranei he kaihautu o naianei;
4. I runga i te wharangi hanga / whakatika kaihautu, tohua te "tātauira"a ka paato i te hono"Tāpiri";
5. I roto i te "Rōpū", tohua "Tauira/Patengi Raraunga" mai i te rarangi, tohua te tauira "Tauira DB PostgreSQL", pehia te paatene "Tīpakohia" ka pehi i te paatene "Whakahōu";

Ka tatari matou mo etahi wa ka mutu ka haere ki "aroturuki" => "Raraunga hou" => "Nga ope"tīpakohia he tūmau me te PostgreSQL => pawhiria"Anga".

Kia pai!

Source: will.com