ProHoster > Π‘Π»ΠΎΠ³ > Maamulka > Dejinta qaabka rasmiga ah ee PostgreSQL ee Zabbix 4.4

Dejinta qaabka rasmiga ah ee PostgreSQL ee Zabbix 4.4

Qof walba raalli.

Zabbix hadda waxay leedahay rasmi Template DB PostgreSQL. Maqaalkan waxaan ku habeyn doonaa Zabbix 4.4.

Dejinta qaabka rasmiga ah ee PostgreSQL ee Zabbix 4.4

XUSUUS

Haddii aad ku fiican tahay Ingiriisiga, markaa waxaan kugula talinayaa inaad ku rakibto template sida waafaqsan buug-gacmeedka rasmiga ah

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

Si kastaba ha ahaatee, maqaalkaygu wuxuu ku xisaabtamayaa nuucyada aan lagu darin xiriirkan.

Diyaarinta qaab-dhismeedka

1. Aad buug-gurigaaga.

cd ~

2. Soo deji utility git oo xidh kaydka rasmiga ah ee Zabbix, kaas oo ku yaal GitHub.

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

3. U tag buugga hagaha leh qaabka PostgreSQL.

cd zabbix/templates/db/postgresql/

Dejinta template wakiilka Zabbix

1. Aynu ku xidhno PostgreSQL.

psql -U postgres

2. Samee isticmaale akhris-kaliya zbx_monitor oo marin u leh server-ka PostgreSQL.

Nooca PostgreSQL ee 10 iyo ka sare:

CREATE USER zbx_monitor WITH PASSWORD '<ВАШ_ΠŸΠΠ ΠžΠ›Π¬>' INHERIT; GRANT pg_monitor TO zbx_monitor;

Nooca PostgreSQL ee 9.6 iyo wixii ka hooseeya:

CREATE USER zbx_monitor WITH PASSWORD '<ВАШ_ΠŸΠΠ ΠžΠ›Π¬>';
GRANT SELECT ON pg_stat_database TO zbx_monitor;

--Для сбора ΠΌΠ΅Ρ‚Ρ€ΠΈΠΊ WAL ΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚Π΅Π»ΡŒ Π΄ΠΎΠ»ΠΆΠ΅Π½ Π±Ρ‹Ρ‚ΡŒ superuser.
ALTER USER zbx_monitor WITH SUPERUSER;

3. Ku koobbi tusaha postgresql/var/lib/zabbix/ tusaha. Haddii aadan haysan zabbix/ directory gudaha /var/lib/, ka dibna samee. Buuga postgresql/hagaha waxaa ku jira faylalka loo baahan yahay si looga soo saaro cabbirada PostgreSQL.

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

4. Ka dib koobi ka dhig faylka template_db_postgresql.conf tusaha qaabeynta wakiilka Zabbix /etc/zabbix/zabbix_agentd.d/ oo dib u bilow wakiilka Zabbix.

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

5. Hadda aan tafatirno feylka pg_hba.conf si aan u oggolaanno xiriirka Zabbix. Faahfaahin dheeraad ah oo ku saabsan faylka pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Fur faylka:

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

Ku dar mid ka mid ah khadadka (Haddii aadan fahmin sababta tan loogu baahan yahay, ka dibna ku dar kaliya khadka koowaad.):

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

XUSUUS

Haddii PostgreSQL laga rakibay kaydka PGDG, ku dar dariiqa pg_isready doorsoomiyaha deegaanka PATH ee isticmaalaha zabbix.

Ikhtiyaar ahaan:

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

* - maadaama aan haysto nooca pgsql 12, waxaad yeelan doontaa waddo ka duwan halkii pgsql-12.

Haddii tan aan la samayn, markaas Xaaladda: Ping had iyo jeer waa hoos.

Ku-daridda qaab-dhismeedka dhinaca hore ee Zabbix

Waxaan aaminsanahay in kuwa u baahan inay ka qaataan cabbirada PostgreSQL mar horeba way garanayeen sida loogu daro qaab-dhismeedka. Sidaa darteed, waxaan si kooban u qeexi doonaa habka.

  1. Tag bogga Zabbix;
  2. Tag bogga"qaabeynta" => "martigeliyaha";
  3. Guji badhanka"Abuur martigeliyaha"ama dooro martigeliyaha jira;
  4. Bogga abuurista/habaynta martida, dooro "habyaalada"oo guji xiriirka"Add";
  5. Gudaha "Kooxda", ka dooro "Templates/Databases" liiska, dooro qaabka"Template DB PostgreSQL", riix batoonka"Dooro"oo taabo badhanka"Cusbooneysii";

Waxaan sugaynaa xoogaa waqti ah ugu dambeyntiina waxaan tagnaa "Monitoring" => "Xogtii ugu dambaysay" => "Hawlwadeennada"dooro server leh PostgreSQL => dhagsii"CodsoΒ«.

Dejinta qaabka rasmiga ah ee PostgreSQL ee Zabbix 4.4
Ku raaxayso!

Source: www.habr.com

Add a comment