ProHoster > Блог > Gudanarwa > Kafa samfurin PostgreSQL na hukuma akan Zabbix 4.4

Kafa samfurin PostgreSQL na hukuma akan Zabbix 4.4

Sannu kowa da kowa.

Zabbix yanzu yana da hukuma Samfura DB PostgreSQL. A cikin wannan labarin za mu saita shi a cikin Zabbix 4.4.

Kafa samfurin PostgreSQL na hukuma akan Zabbix 4.4

NOTE

Idan kuna da kyau tare da Ingilishi, to, ina ba da shawarar shigar da samfuri bisa ga jagorar hukuma

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

Koyaya, labarina yayi la'akari da nuances waɗanda ba a haɗa su cikin wannan hanyar haɗin yanar gizon ba.

Ana shirya samfuri

1. Je zuwa kundin adireshin gidan ku.

cd ~

2. Zazzage kayan aikin git ɗin kuma rufe ma'ajin Zabbix na hukuma, wanda ke kan GitHub.

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

3. Je zuwa kundin adireshi tare da samfurin PostgreSQL.

cd zabbix/templates/db/postgresql/

Kafa samfuri don wakilin Zabbix

1. Bari mu haɗa zuwa PostgreSQL.

psql -U postgres

2. Ƙirƙiri mai amfani mai karantawa kawai zbx_monitor tare da samun dama ga uwar garken PostgreSQL.

Don sigar PostgreSQL 10 da sama:

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

Don sigar PostgreSQL 9.6 da ƙasa:

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

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

3. Kwafi postgresql/ directory zuwa /var/lib/zabbix/ directory. Idan ba ku da zabbix/ directory a /var/lib/, to, ƙirƙira shi. Postgresql/ directory ya ƙunshi fayilolin da ake buƙata don dawo da awo daga PostgreSQL.

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

4. Sa'an nan kwafi template_db_postgresql.conf fayil zuwa Zabbix wakilin sanyi directory /etc/zabbix/zabbix_agentd.d/ da kuma zata sake farawa da Zabbix wakili.

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

5. Yanzu bari mu gyara pg_hba.conf fayil don ba da damar haɗi zuwa Zabbix. Ƙarin cikakkun bayanai game da pg_hba.conf fayil: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Bude fayil ɗin:

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

Ƙara ɗaya daga cikin layin (Idan ba ku fahimci dalilin da yasa ake buƙatar wannan ba, to sai ku ƙara layin farko kawai.):

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

NOTE

Idan an shigar da PostgreSQL daga ma'ajiyar PGDG, ƙara hanyar zuwa pg_isready zuwa canjin yanayin PATH don mai amfani da zabbix.

A matsayin zaɓi:

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

* - tunda ina da pgsql version 12, zaku sami wata hanya ta daban maimakon pgsql-12.

Idan ba a yi haka ba, to Matsayi: Ping koyaushe zai kasance ƙasa.

Ƙara samfuri akan gaban Zabbix

Na yi imani cewa waɗanda suke buƙatar ɗaukar awo daga PostgreSQL sun riga sun san yadda ake ƙara samfuri. Saboda haka, zan bayyana tsarin a takaice.

  1. Jeka shafin Zabbix;
  2. Jeka shafin"Kanfigareshan" =>"watsa shiri";
  3. Danna maballin"Ƙirƙiri mai masaukin baki"ko zaɓi mai masaukin baki;
  4. A kan shafin ƙirƙira/gyara, zaɓi "Samfura"sannan ku danna link"Add";
  5. A cikin "Group", zaɓi "Tsarin / Databases" daga lissafin, zaɓi samfuri "Samfura DB PostgreSQL", danna maballin"Select"kuma danna maɓallin"Update";

Muna jiran wani lokaci daga karshe mu tafi "Kulawa" =>"Sabbin bayanai" =>"Mai watsa shiri"zaɓi uwar garken tare da PostgreSQL => danna"Aiwatar".

Kafa samfurin PostgreSQL na hukuma akan Zabbix 4.4
Enjoy!

source: www.habr.com

Add a comment