PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this scenario, the server at 10.0.30.1 is still the primary PostgreSQL server. Follow these steps to change an asynchronous PostgreSQL server into a synchronous replica:

1. Revise the primary_conninfo parameter on the recovery server to add application_name:

primary_conninfo = 'host=10.0.30.1 user=rep_user application_name=pgha2

2. Restart the streaming server with systemctl as standard:

systemctl restart postgresql@12-main

3. Or alternatively, use the following:

systemctl restart postgresql-12

4. Change the synchronous_standby_names and synchronous_commit settings in the postgresql.conf file on the primary server to read the following:

synchronous_commit = 'on' 
synchronous_standby_names = 'pgha2'

5. Reload the configuration ...