Mastering PostgreSQL 12 - Third Edition

Performing a basic setup

In this section, we will learn how to set up asynchronous replication quickly and easily. The goal is to set up a system that consists of two nodes.

Basically, most of the work has already been done for WAL archiving. However, to make it easy to understand, we will look at the entire process of setting up streaming because we cannot assume that WAL shipping is really already set up as needed.

The first thing to do is to go to the postgresql.conf file and adjust the following parameters:

wal_level = replicamax_wal_senders = 10         # or whatever value >= 2 hot_standby = on             # in already a default setting

Some of these are already the default options starting with PostgreSQL 10.0.

Just as we have done previously, the wal_level ...