ProHoster > Blog > Tsamaiso > Ho theha template ea semmuso ea PostgreSQL ho Zabbix 4.4

Ho theha template ea semmuso ea PostgreSQL ho Zabbix 4.4

Lumela.

Hona joale Zabbix o na le ofisiri Setšoantšo sa DB PostgreSQL. Sehloohong sena re tla e hlophisa ho Zabbix 4.4.

Ho theha template ea semmuso ea PostgreSQL ho Zabbix 4.4

TIISETSO

Haeba u tseba Senyesemane hantle, ke khothaletsa ho kenya template ho latela bukana ea molao

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

Leha ho le joalo, sengoloa sa ka se nka li-nuances tse sa kenyelletsoeng sehokelong sena.

Ho lokisetsa template

1. E-ea bukeng ea hau ea lapeng.

cd ~

2. Khoasolla sesebelisoa sa git 'me u hatelle polokelo ea semmuso ea Zabbix, e fumanehang ho GitHub.

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

3. E-ea bukeng e nang le template ea PostgreSQL.

cd zabbix/templates/db/postgresql/

Ho theha template bakeng sa moemeli oa Zabbix

1. Ha re ikopanye le PostgreSQL.

psql -U postgres

2. Etsa zbx_monitor ea ho bala feela ea nang le monyetla oa ho fihlella seva sa PostgreSQL.

Bakeng sa mofuta oa 10 oa PostgreSQL le ho feta:

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

Bakeng sa mofuta oa 9.6 oa PostgreSQL le ka tlase:

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

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

3. Kopitsa postgresql/ directory ho /var/lib/zabbix/ directory. Haeba ha u na zabbix/ directory ho /var/lib/, e bopa. Postgresql / directory e na le lifaele tse hlokahalang ho fumana metrics ho PostgreSQL.

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

4. Ebe u kopitsa faele ea template_db_postgresql.conf bukeng ea tlhophiso ea moemeli oa Zabbix /etc/zabbix/zabbix_agentd.d/ ebe o qala hape moemeli oa Zabbix.

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

5. Joale ha re fetoleng faele ea pg_hba.conf ho lumella khokahanyo ho Zabbix. Lintlha tse ling mabapi le faele ea pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Bula faele:

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

Kenya o mong oa mela (Haeba u sa utloisise hore na ke hobane'ng ha sena se hlokahala, joale eketsa mola oa pele feela.):

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

TIISETSO

Haeba PostgreSQL e kentsoe ho tsoa sebakeng sa polokelo ea PGDG, eketsa tsela e eang ho pg_isready ho PATH e fapaneng ea tikoloho bakeng sa mosebelisi oa zabbix.

E le khetho:

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

* - kaha ke na le mofuta oa 12 oa pgsql, u tla ba le tsela e fapaneng ho fapana le pgsql-12.

Haeba sena se sa etsoe, Status: Ping e tla lula e le Fatše.

Ho eketsa template ho Zabbix frontend

Ke lumela hore ba hlokang ho nka metrics ho PostgreSQL ba se ba ntse ba tseba ho eketsa litempele. Ka hona, ke tla hlalosa mokhoa ona ka bokhutšoanyane.

  1. Eya leqepheng la Zabbix;
  2. Eya leqepheng "phetolo=> "Sebetsa";
  3. Tobetsa konopo "Etsa moamoheli"kapa khetha moamoheli ea teng;
  4. Leqepheng la pōpo / ho hlophisa, khetha "dithempleite"'me u tobetse sehokelong"Add";
  5. Ho "Sehlopha", khetha "Templates/Databas" lethathamong, khetha template "Setšoantšo sa DB PostgreSQL", tobetsa konopo"khetha"Ebe o tobetsa konopo"Update";

Re ema nakoana ebe re ea ho "go baya leitlho=> "Lintlha tsa morao-rao=> "Mabotho"khetha seva ka PostgreSQL => tobetsa"Etsa kopo".

Ho theha template ea semmuso ea PostgreSQL ho Zabbix 4.4
Thabela!

Source: www.habr.com

Eketsa ka tlhaloso