PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this scenario, the server at 10.0.30.1 is the primary PostgreSQL server, and 10.0.30.2 will be the asynchronous replica. Follow these steps to build a PostgreSQL asynchronous replica:

1. Give the rep_user user a password with this SQL statement:

ALTER USER rep_user WITH PASSWORD 'newpass';

2. On the primary server, modify the pg_hba.conf line and remove any references to the rep_user user. Then, add this line:

host   replication   rep_user   10.0.30.2/32   md5

3. Reload the configuration files on the primary server with the following command as the postgres user:

pg_ctl -D /db/pgdata reload

4. On the replica server, create a file named .pgpass in the postgres user's home directory with the following contents:

10.0.30.1:*:replication:rep_user:newpass ...