PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

This recipe has a lot of moving parts, but it merely looks more complicated than it really is. We begin by finding the directory where supplementary configuration files are stored. Once this is located, we can create an entry to watch our PostgreSQL servers. To do this, we create a file named db_conf.cfg.

You don't have to use db_conf.cfg. Nagios should recognize any file that ends with a .cfg extension. If you'd rather separate hosts, host groups, and services, feel free to do so.

The order of the elements that we are creating does not matter; Nagios has a very advanced parser that checks configuration entries all at once. Still, it's more logical to define things before they're used, so we've elected to begin with the check ...