3. Pindhah menyang direktori karo cithakan PostgreSQL.
cd zabbix/templates/db/postgresql/
Nyetel cithakan kanggo agen Zabbix
1. Ayo nyambung menyang PostgreSQL.
psql -U postgres
2. Nggawe zbx_monitor pangguna mung diwaca kanthi akses menyang server PostgreSQL.
Kanggo PostgreSQL versi 10 lan luwih dhuwur:
CREATE USER zbx_monitor WITH PASSWORD '<ΠΠΠ¨_ΠΠΠ ΠΠΠ¬>' INHERIT; GRANT pg_monitor TO zbx_monitor;
Kanggo PostgreSQL versi 9.6 lan ngisor:
CREATE USER zbx_monitor WITH PASSWORD '<ΠΠΠ¨_ΠΠΠ ΠΠΠ¬>';
GRANT SELECT ON pg_stat_database TO zbx_monitor;
--ΠΠ»Ρ ΡΠ±ΠΎΡΠ° ΠΌΠ΅ΡΡΠΈΠΊ WAL ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Ρ Π΄ΠΎΠ»ΠΆΠ΅Π½ Π±ΡΡΡ superuser.
ALTER USER zbx_monitor WITH SUPERUSER;
3. Salin direktori postgresql/ menyang direktori /var/lib/zabbix/. Yen sampeyan ora duwe direktori zabbix/ ing /var/lib/, banjur gawe. Direktori postgresql / ngemot file sing dibutuhake kanggo njupuk metrik saka PostgreSQL.
cp -r postgresql/ /var/lib/zabbix/
4. Banjur nyalin file template_db_postgresql.conf menyang direktori konfigurasi agen Zabbix /etc/zabbix/zabbix_agentd.d/ lan miwiti maneh agen Zabbix.