ProHoster > Π‘Π»ΠΎΠ³ > administratio > PostgreSQL template officialem constituens in Zabbix 4.4

PostgreSQL template officialem constituens in Zabbix 4.4

Omnis salve.

Zabbix nunc officialem habet Formula DB PostgreSQL. Hoc articulum configurabimus in Zabbix 4.4.

PostgreSQL template officialem constituens in Zabbix 4.4

NOTA

Si bene cum Anglis es, tunc commendo Formulam institutionis secundum manualem officialem

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

Autem, mi dictum tempus suscipit nuances quae in hac pagina non continentur.

Praeparans template

1. Vade ad domum tuam presul.

cd ~

2. Download the git utilitatem et clone in promptuario officiali Zabbix, quod situm est in GitHub.

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

3. vade in indicem cum PostgreSQL template.

cd zabbix/templates/db/postgresql/

Exemplum constituens pro agente Zabbix

1. Sit scriptor PostgreSQL ad coniungere.

psql -U postgres

2. Creare solum user zbx_monitorem cum accessu ad servo PostgreSQL legere.

Pro PostgreSQL versio 10 et superior;

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

Pro PostgreSQL versio 9.6 et infra:

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

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

3. Effingo directorium postgresql/ ad /var/lib/zabbix/. Si directorium zabbix/in /var/lib/ non habes, eam crea. Postgresql / directorium continet tabellas ad metricos reciperandos ex PostgreSQL.

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

4. Tunc effingo tabulam template_db_postgresql.conf in directorio figurae agentis Zabbix /etc/zabbix/zabbix_agentd.d/ et sileo procuratorem Zabbix.

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

5. Nunc limam pg_hba.conf emendemus ut nexum cum Zabbix permittat. Plura de fasciculo pg_hba.conf: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html.

Aperi tabella:

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

Unam lineam adde (Si hoc cur opus sit non intellegis, primam tantum lineam addes.);

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

NOTA

Si PostgreSQL ex repositorio PGDG installatur, adde viam ad pg_is paratam ad PATH environment variabilis pro usore zabbix.

Cum bene:

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

* - Cum pgsql versionem 12 habuero, aliam viam pro pgsql-12 habebis.

Si hoc non fit, Status: Ping Semper Down erit.

Addit exemplum in Zabbix frontend

Credo eos, qui metrics e PostgreSQL sumere necesse est, iam exempla noverunt addere. Quare breviter processum describemus.

  1. Vade ad paginam Zabbix;
  2. Perge ad paginam "configuration" => "Host";
  3. Click in puga pyga "Hostiam crea"vel exercitum existentium eligere;
  4. Ad exercitum creatio/paginam edendam, elige "Templates" et deprime nexum "Add";
  5. In "Group", eligere "Templates/Databases" ex indice, eligere exemplum "Formula DB PostgreSQL", premere puga pyga "select"Et premere puga"Update";

Expectamus aliquamdiu et tandem ad "Cras" => "Tardus data" => "sabaoth"elige servo cum PostgreSQL => preme"Applicare".

PostgreSQL template officialem constituens in Zabbix 4.4
Enjoy!

Source: www.habr.com