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.