ProHoster > Blog > Utongi > Kumisikidza iyo yepamutemo PostgreSQL template paZabbix 4.4

Kumisikidza iyo yepamutemo PostgreSQL template paZabbix 4.4

Mhoroi munhu wese.

Zabbix iye zvino ane mukuru DB PostgreSQL template. Muchikamu chino tichazvigadzirisa muZabbix 4.4.

Kumisikidza iyo yepamutemo PostgreSQL template paZabbix 4.4

ONA

Kana iwe wakanaka neChirungu, saka ini ndinokurudzira kuisa iyo template maererano neiyo official manual

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

Nekudaro, chinyorwa changu chinotarisa nuances isina kubatanidzwa mune iyi link.

Kugadzirira template

1. Enda kudhairekitori rako repamba.

cd ~

2. Dhawunirodha git utility uye clone iyo yepamutemo Zabbix repository, iyo iri paGitHub.

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

3. Enda kudhairekitori nePostgreSQL template.

cd zabbix/templates/db/postgresql/

Kumisikidza template yemumiriri weZabbix

1. Ngatibatanei nePostgreSQL.

psql -U postgres

2. Gadzira mushandisi wekuverenga chete zbx_monitor ane mukana weiyo PostgreSQL server.

YePostgreSQL vhezheni 10 uye yepamusoro:

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

YePostgreSQL vhezheni 9.6 uye pazasi:

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

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

3. Kopa postgresql/dhairekitori ku /var/lib/zabbix/dhairekitori. Kana iwe usina zabbix/ dhairekitori mu/var/lib/, wobva wagadzira. Iyo postgresql / dhairekitori ine mafaera anodiwa kuti atore metrics kubva kuPostgreSQL.

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

4. Wobva wakopa template_db_postgresql.conf faira kuZabbix agent configuration directory /etc/zabbix/zabbix_agentd.d/ uye tangazve mumiririri weZabbix.

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

5. Zvino ngatigadzirise pg_hba.conf faira kuti tibvumire kubatana kuZabbix. Mamwe ruzivo nezve pg_hba.conf faira: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Vhura faira:

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

Wedzera imwe yemitsara (Kana iwe usinganzwisise kuti nei izvi zvichidikanwa, wobva wawedzera chete mutsara wekutanga.):

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

ONA

Kana PostgreSQL yakaiswa kubva kuPGDG repository, wedzera nzira yeku pg_isready kune PATH nharaunda inosiyana yemushandisi we zabbix.

Seimwe sarudzo:

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

* - sezvo ndine pgsql vhezheni 12, iwe uchave neimwe nzira pane pgsql-12.

Kana izvi zvikasaitwa, ipapo Mamiriro: Ping ichagara iri Pasi.

Kuwedzera template pane Zabbix kumberi

Ini ndinotenda kuti avo vanoda kutora metrics kubva kuPostgreSQL vatoziva kuwedzera matemplate. Nokudaro, ini ndichatsanangura nzira yacho muchidimbu.

  1. Enda kuZabbix peji;
  2. Enda kupeji "Configuration=> "Host";
  3. Dzvanya pabhatani "Gadzira mugamuchiri"kana sarudza munhu aripo;
  4. Pa peji rekugadzira / kugadzirisa, sarudza iyo "Templates"uye tinya pane link"wedzera";
  5. Mu "Boka", sarudza "Matemplate / Dhatabhesi" kubva pane rondedzero, sarudza iyo template "DB PostgreSQL template", dzvanya bhatani"sarudza"uye tinya bhatani"Update";

Tinomirira kwechinguva tozoenda ku"Monitoring=> "Latest data=> "Hosts"sarudza sevha ine PostgreSQL => tinya"Shandisa".

Kumisikidza iyo yepamutemo PostgreSQL template paZabbix 4.4
Nakidzwa!

Source: www.habr.com

Voeg