zapgix
PostgreSQL Monitoring
This script is part of a monitoring solution that allows to monitor several services and applications.
For more information about this monitoring solution please check out this post on my site.
Dependencies
Packages
- ksh
- sudo
Debian/Ubuntu
#~ sudo apt install ksh sudo
#~
Red Hat
#~ sudo yum install ksh sudo
#~
Deploy
PostgreSQL
We may need to enable some extensions.
postgres=# CREATE EXTENSION pg_buffercache;
CREATE EXTENSION
postgres=# \dx pg_buffercache
List of installed extensions
Name | Version | Schema | Description
----------------+---------+--------+---------------------------------
pg_buffercache | 1.0 | public | examine the shared buffer cache
(1 row)
postgres=#
Zabbix
Zabbix user has to have sudo privileges.
#~ cat /etc/sudoers.d/user_zabbix
# Allow the user zabbix to execute any command without password
Defaults:zabbix !requiretty
zabbix ALL=(ALL:ALL) NOPASSWD:ALL
Then you can run the deploy_zabbix script
#~ git clone https://github.com/sergiotocalini/zapgix.git
#~ sudo ./zapgix/deploy_zabbix.sh
#~ sudo systemctl restart zabbix-agent
Note: the installation has to be executed on the zabbix agent host and you have to import the template on the zabbix web. The default installation directory is /etc/zabbix/scripts/agentd/zapgix/