This project provides comprehensive monitoring of PostgreSQL servers using a natively compiled Zabbix agent module, written in C.
N.B. Zabbix 6+ users will probably prefer the official support for PostrgreSQL
available in zabbix_agent2, documented here.
A preconfigured Zabbix Template is also included for your convenience.
Sources in this project are used to compile libzbxpgsql.so which may be
loaded by a Zabbix agent using the LoadModule directive. The module enables
discovery and monitoring of tablespaces, databases, namespaces, tables,
indexes, etc.
- Read the documentation
- Download the packages
- Clone the sources
- Follow the author
To compile the agent module the following items are required:
- GNU build tools (
make,gcc,autoconf,automake,libtool,m4, etc.) - Zabbix sources
- libpq development headers
If you are building from sources cloned from GitHub, you first need to
regenerate the build scripts using ./autogen.sh. Otherwise:
./configure --with-zabbix=/usr/src/zabbix
make
sudo make install
Module file libzbxpgsql.so will then be installed in /usr/local/lib.
If you are using a packaged version of Zabbix, you may with to redirect the installation directories as follows:
$ sudo make prefix=/usr sysconfdir=/etc libdir=/usr/lib64 install
Note: Please use a clean copy of the Zabbix source code. Once you configure or build the Zabbix sources, they are no longer useful for building this module.
To build the RPM package on a RHEL6+ family system with rpm-build installed:
make rpm
libzbxpgsql - A PostgreSQL monitoring module for Zabbix Copyright (C) 2016 - Ryan Armstrong ryan@cavaliercoder.com
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.