PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For the purposes of this recipe, we will need one server named pgha1. As always, the /db/pgdata path will be our default data directory. Follow these steps:

1. Connect to PostgreSQL and execute the following commands to create a user and database for managing repmgr:

CREATE USER repmgr WITH SUPERUSER REPLICATION; 
CREATE DATABASE repmgr OWNER repmgr;

2. Modify the postgresql.conf file and set the following parameters:

shared_preload_libraries = 'pg_stat_statements, repmgr' 
wal_log_hints = 'on' 

3. Modify the pg_hba.conf file and add the following lines:

host   all           repmgr   10.0.30.0/24   trust 
host   replication   repmgr   10.0.30.0/24   trust 

4. Restart the PostgreSQL service with this command on Debian-based systems

sudo systemctl restart ...