PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For these instructions, 10.0.30.1 (pgha1) is the provider PostgreSQL node, and 10.0.30.2 (pgha2) is our desired subscriber. Follow these instructions to activate Slony on the postgres default database:

1. Provide the rep_user database user with superuser capabilities by running this SQL statement on both PostgreSQL nodes:

ALTER USER rep_user WITH SUPERUSER;

2. Enter the following line in the .pgpass file for the postgres OS user on both nodes:

*:*:postgres:rep_user:passwordhere 

3. Ensure that the following line exists within the pg_hba.conf file on the master node:

host   postgres   rep_user   10.0.30.2/32   md5 

4. Ensure that the following line exists within the pg_hba.conf file on the subscriber node:

host postgres rep_user 10.0.30.1/32 ...