Awesome

libzbxpgsql

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

Installation

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

License

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.