PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

As usual for these instructions, 10.0.30.1 (pgha1) is the provider PostgreSQL node, and 10.0.30.2 (pgha2) is the subscriber. Follow these steps to install pglogical:

1. Ensure that the pg_hba.conf file on the provider and subscriber servers contains these lines:

host   all           rep_user   10.0.30.1/24   md5
host   replication   rep_user   10.0.30.1/24   md5

2. Ensure that the wal_level, max_replication_slots, and shared_preload_libraries settings in postgresql.conf are set as follows on the provider server:

wal_level = logical 
max_replication_slots = 10 
shared_preload_libraries = 'pg_stat_statements, pglogical' 

3. Ensure the shared_preload_libraries setting is set as follows on the subscriber server:

shared_preload_libraries = 'pg_stat_statements, ...