PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

Since repmgr works as both a PostgreSQL extension and a service daemon, we've chosen to differentiate between installing the software packages and installing repmgr components in the next recipe. To that end, we've provided both apt and yum commands to install the appropriate repmgr package for prominent supported Linux distributions.

Since repmgr uses a PostgreSQL extension, it is version dependent, so make sure that you install the version that matches your PostgreSQL installation.

Once the package itself is installed, we merely need to ensure that every node can communicate via passwordless SSH through the postgres user. This is a fairly common configuration, so it's possible that this has already been done. Regardless, ...