ืืขืื ืึทืืขืืขื.
ืืืืืงืก ืืื ืืืฆื ื ืืืืืืขืจ ืืืกืืขืจ DB PostgreSQL. ืืื ืืขื ืึทืจืืืงื ืืืจ ืืืขืื ืงืึทื ืคืืืืขืจ ืขืก ืืื Zabbix 4.4.
NOTE
ืืืื ืืืจ ืืขื ื ืืื ืืื ืขื ืืืืฉ, ืืื ืจืขืงืึธืืขื ืืืจื ืฆื ืื ืกืืึทืืืจื ืื ืืืกืืขืจ ืืืื ืืขืจ ืืึทืึทืืืขืจ ืืึทื ืืึทื
github.com/zabbix/zabbix/tree/master/templates/db/postgresql ืึธืืขืจ, ืืืื ืึทืจืืืงื ื ืขืื ืืื ืืฉืืื ื ืืึทื ืกืื ืืืึธืก ืืขื ืขื ื ืืฉื ืึทืจืืึทื ืืขืจืขืื ื ืืื ืืขื ืืื ืง.
ืคึผืจืืคึผืขืจืื ื ืื ืืืกืืขืจ
1. ืืืื ืฆื ืืืื ืืืื ืืืขืืืืืึทืืขืจ.
cd ~
2. ืืจืืคืงืืคืืข ืื ืืื ื ืืฆื ืืื ืงืืึธืื ืื ืืึทืึทืืืขืจ Zabbix ืจืืคึผืึทืืึทืืึธืจื, ืืืึธืก ืืื ืืืื ืืืืฃ GitHub.
yum -y install git
git clone https://github.com/zabbix/zabbix.git
3. ืืืื ืฆื ืื ืืืขืืืืืึทืืขืจ ืืื ืื PostgreSQL ืืืกืืขืจ.
cd zabbix/templates/db/postgresql/
ืืึทืฉืืขืืืงื ืึท ืืืกืืขืจ ืคึฟืึทืจ ืื Zabbix ืึทืืขื ื
1. ืืึธืืืจ ืคืึทืจืืื ืื ืฆื PostgreSQL.
psql -U postgres
2. ืฉืึทืคึฟื ืึท ืืืืขื -ืืืืื ืืึทื ืืฆืขืจ zbx_monitor ืืื ืึทืงืกืขืก ืฆื ืื PostgreSQL ืกืขืจืืืขืจ.
ืคึฟืึทืจ PostgreSQL ืืืขืจืกืืข 10 ืืื ืืขืืขืจ:
CREATE USER zbx_monitor WITH PASSWORD '<ะะะจ_ะะะ ะะะฌ>' INHERIT; GRANT pg_monitor TO zbx_monitor;
ืคึฟืึทืจ PostgreSQL ืืืขืจืกืืข 9.6 ืืื ืืืืืืขืจ:
CREATE USER zbx_monitor WITH PASSWORD '<ะะะจ_ะะะ ะะะฌ>';
GRANT SELECT ON pg_stat_database TO zbx_monitor;
--ะะปั ัะฑะพัะฐ ะผะตััะธะบ WAL ะฟะพะปัะทะพะฒะฐัะตะปั ะดะพะปะถะตะฝ ะฑััั superuser.
ALTER USER zbx_monitor WITH SUPERUSER;
3. ื ืึธืืืึทืื ืื postgresql/ ืืืขืืืืืึทืืขืจ ืฆื ืื /var/lib/zabbix/ ืืืขืืืืืึทืืขืจ. ืืืื ืืืจ ืืึธื ื ืื ืืึธืื ืึท zabbix/ ืืืขืืืืืึทืืขืจ ืืื /var/lib/, ืฉืึทืคึฟื ืขืก. ืื postgresql / ืืืขืืืืืึทืืขืจ ืึผืืื ืื ืืขืงืขืก ืืืจืฃ ืฆื ืฆืืจืืงืงืจืืื ืืขืืจืืงืก ืคึฟืื PostgreSQL.
cp -r postgresql/ /var/lib/zabbix/
4. ื ืึธืืืึทืื ืื template_db_postgresql.conf ืืขืงืข ืฆื ืื Zabbix ืึทืืขื ื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืืขืืืืืึทืืขืจ /etc/zabbix/zabbix_agentd.d/ ืืื ืจืืกืืึทืจื ืื Zabbix ืึทืืขื ื.
cp template_db_postgresql.conf /etc/zabbix/zabbix_agentd.d/
5. ืืืฆื ืืึธืื ืก ืจืขืืึทืืืจื ืื pg_hba.conf ืืขืงืข ืฆื ืืึธืื ืงืฉืจ ืฆื Zabbix. ืืขืจ ืืขืืึทืืืก ืืืขืื ืื pg_hba.conf ืืขืงืข:
ืขืคึฟืขื ืขื ืื ืืขืงืข:
vi /var/lib/pgsql/12/data/pg_hba.conf
ืืืื ืืืื ืขืจ ืคืื ืื ืฉืืจืืช (ืืืื ืืืจ ืืึธื ื ืื ืคึฟืึทืจืฉืืืื ืืืึธืก ืืึธืก ืืื ืืืจืฃ, ืืืื ืืืืื ืื ืขืจืฉืืขืจ ืฉืืจื.):
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
NOTE
ืืืื PostgreSQL ืืื ืืื ืกืืึทืืืจื ืคึฟืื ืื PGDG ืจืืคึผืึทืืึทืืึธืจื, ืืืืื ืืขื ืืจื ืฆื pg_isready ืฆื ืื PATH ืกืืืืืืข ืืืึทืืขืืืืืง ืคึฟืึทืจ ืื zabbix ืืึทื ืืฆืขืจ.
ืืื ืึทื ืึธืคึผืฆืืข:
ln -s /usr/pgsql-12/bin/pg_isready /usr/bin/pg_isready
* - ืืื ื ืืื ืืึธืื pgsql ืืืขืจืกืืข 12, ืืืจ ืืืขื ืืึธืื ืึท ืึทื ืืขืจืฉ ืืืขื ืึทื ืฉืืึธื ืคืื pgsql-12.
ืืืื ืืึธืก ืืื ื ืืฉื ืืขืืื, ืกืืึทืืืก: ืคึผืื ื ืืืขื ืฉืืขื ืืืง ืืืื ืึทืจืึธืคึผ.
ืึทืืื ื ืึท ืืืกืืขืจ ืืืืฃ ืื Zabbix ืคืจืึธื ืืขื ื
ืืื ืืืืืื ืึทื ืื ืืืืก ืืึทืจืคึฟื ืฆื ื ืขืืขื ืืขืืจืืงืก ืคืื PostgreSQL ืฉืืื ืืืืกื ืืื ืฆื ืืืืื ืืขืืคึผืืึทืืขืก. ืืขืจืืืขืจ, ืืื ืืืขื ืืึทืฉืจืืึทืื ืืขื ืคึผืจืึธืฆืขืก ืืขืงืืฆืขืจ.
- ืืืื ืฆื ืื ืืึทืืืงืก ืืืึทื;
- ืืืื ืฆื ืื ืืืึทื "ืงืึธื ืคืืืืจืึทืืืึธื" => "ืืึทืืขืืึธืก";
- ืืจืืงื ืืืืฃ ืื ืงื ืขืคึผื "ืฉืึทืคึฟื ืืึทืืขืืึธืก"ืึธืืขืจ ืืืืกืงืืืึทืื ืึท ืืืืืกืืื ื ืืึทืืขืืึธืก;
- ืืืืฃ ืืขืจ ืืึทืืขืืึธืก ืฉืึทืคืื ื / ืขืืืืื ื ืืืึทื, ืกืขืืขืงืืืจื ืืขื "ืืขืืคึผืืึทืืขืก"ืืื ืืื ืืื ืืืืฃ ืื ืืื ืง"ืฆืืืขืื";
- ืืื "ืืจืืคืข", ืกืขืืขืงืืืจื "ืืขืืคึผืืึทืืขืก / ืืึทืืึทืืืืกืื" ืคืื ืืขืจ ืจืฉืืื, ืกืขืืขืงืืืจื ืืขื ืืืกืืขืจ "ืืืกืืขืจ DB PostgreSQL", ืืจืืงื ืืขื ืงื ืขืคึผื "ืงืืืึทืื"ืืื ืืจืืงื ืืขื ืงื ืขืคึผื"ืืขืจืืืึทื ืืืงื";
ืืืจ ืืืึทืจืื ืคึฟืึทืจ ืขืืืขืืข ืืึธื ืืื ืืขืกืึธืฃ ืืืื ืฆื "ืืึธื ืืืึธืจืื ื" => "ืืขืฆื ืืึทืืข" => "Hosts"ืกืขืืขืงืืืจื ืึท ืกืขืจืืืขืจ ืืื PostgreSQL => ืืื "ืฆืืืืืื".
ืื ืื!
ืืงืืจ: www.habr.com