Dealing with monitoring tools
There are a couple of monitoring tools around these days that make your life easier.
One of the most popular monitoring tools around is Nagios. It is widely used and supports a variety of software components.
If you want to use Nagios to monitor your PostgreSQL cluster, it is necessary to install a plugin capable of running tests relevant to replication. Such plugins are also available for PostgreSQL, and can be downloaded for free from http://bucardo.org/wiki/Check_postgres. The Bucardo plugins for Nagios are not just able to test replication but are also a standard software component for monitoring PostgreSQL as a whole.
Installing check_postgres
Once you have downloaded the plugin from the Bucardo website, it is easy ...
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
