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 the subscriber. Follow these instructions on the provider system (unless informed otherwise) to activate Bucardo:

1. Enter the following line in the .pgpass file for the postgres user:

*:*:*:bucardo:passwordhere 

2. Ensure that the following line exists within the pg_hba.conf file on both systems:

host   all   bucardo   10.0.30.1/24   md5

3. Reload the PostgreSQL service on both nodes with the following command as the postgres user:

pg_ctl -D /db/pgdata reload

4. Next, create a bucardo user in the database by executing the following command as the postgres user:

CREATE USER bucardo WITH PASSWORD 'newpass' SUPERUSER;  

5. Create a bucardo ...