PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For the purposes of this recipe, pgha1 will remain our primary node, and the replica will be pgha2. As always, the /db/pgdata path will be our default data directory.

All of these commands should be executed from pgha2. Follow these steps to produce a fully functional repmgr replica:

1. Create a repmgr.conf file as described in the Installing and configuring repmgr recipe on pgha2, but make the following changes to the stated parameters:

node_id = 2 
node_name = 'pgha2' 
conninfo = 'host=pgha2 port=5432 dbname=repmgr user=repmgr' 

2. Clone the pgha1 node with the following command as the postgres user. Executed this command on pgha2:

repmgr standby clone -h pgha1 -U repmgr -d repmgr

3. Start the new replica as the postgres user ...