Faʻatulagaina le faʻataʻitaʻiga PostgreSQL aloaia ile Zabbix 4.4

Talofa tagata uma.

Ua iai nei le ofisa aloaia a Zabbix Fa'ata'ita'iga DB PostgreSQL. I lenei tusiga o le a matou faʻatulagaina i le Zabbix 4.4.

FAʻAALIGA

Afai e te lelei i le Igilisi, ona ou fautuaina lea e faʻapipiʻi le faʻataʻitaʻiga e tusa ai ma le tusi lesona aloaia

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

Ae ui i lea, o laʻu tusiga e amanaʻia nuances e le o aofia ai i lenei sootaga.

Saunia le mamanu

1. Alu i lau lisi o fale.

cd ~

2. Fa'asolo mai le git utility ma fa'apipi'i le faleteuoloa aloaia a Zabbix, lea o lo'o i luga ole GitHub.

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

3. Alu i le lisi ma le PostgreSQL template.

cd zabbix/templates/db/postgresql/

Faʻatulagaina se faʻataʻitaʻiga mo le sui Zabbix

1. Tatou fa'afeso'ota'i i le PostgreSQL.

psql -U postgres

2. Fausia se tagata faitau-na'o le zbx_monitor ma avanoa i le PostgreSQL server.

Mo PostgreSQL version 10 ma maualuga atu:

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

Mo PostgreSQL version 9.6 ma lalo:

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

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

3. Kopi le postgresql/ directory i le /var/lib/zabbix/ directory. Afai e leai sau zabbix/ directory i /var/lib/, ona fai lea. O le postgresql / directory o loʻo i ai faila e manaʻomia e toe aumai ai metrics mai PostgreSQL.

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

4. Ona kopi lea o le faila template_db_postgresql.conf i le Zabbix agent configuration directory /etc/zabbix/zabbix_agentd.d/ ma toe amata le Zabbix agent.

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

5. Se'i o tatou fa'asa'o le faila pg_hba.conf e fa'ataga ai le feso'ota'iga i le Zabbix. Fa'amatalaga atili e uiga i le faila pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Tatala le faila:

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

Faʻaopoopo se tasi o laina (Afai e te le malamalama pe aisea e manaʻomia ai lenei mea, faʻaopoopo naʻo le laina muamua.):

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

FAʻAALIGA

Afai e faʻapipiʻi le PostgreSQL mai le fale teu oloa PGDG, faʻaopoopo le ala ile pg_isready ile PATH environment variable mo le zabbix user.

O se filifiliga:

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

* - talu ai o loʻo ia te aʻu le pgsql version 12, o le ae maua se auala ese nai lo le pgsql-12.

Afai e le faia lenei mea, o lona uiga Tulaga: Ping o le a i lalo i taimi uma.

Fa'aopoopoina se fa'ata'ita'iga ile pito i luma o le Zabbix

Ou te talitonu oi latou e manaʻomia le suʻeina o metrics mai PostgreSQL ua uma ona latou iloa pe faʻafefea ona faʻaopoopo faʻataʻitaʻiga. O lea la, o le a ou faamatalaina puupuu le faagasologa.

1. Alu i le itulau Zabbix;
2. Alu i le itulau "Configuration" => "matai";
3. Kiliki i le ki "Fausia le talimalo"pe filifili se talimalo o loʻo iai;
4. I luga o le fale talimalo / itulau teuteu, filifili le "Mamanu" ma kiliki i luga o le sootaga "Faaopoopo";
5. I le "Group", filifili "Templates/Databases" mai le lisi, filifili le mamanu "Fa'ata'ita'iga DB PostgreSQL", oomi le faamau"filifili"ma oomi le faamau"tuulata";

Matou te faʻatali mo sina taimi ma mulimuli ane alu i "mataituina" => "Fa'amatalaga lata mai" => "Au"filifili se server ma PostgreSQL => kiliki"talosaga".

Fiafia!

puna: www.habr.com