In this section, you will learn how to set up asynchronous replication quickly and easily. The goal is to set up a system consisting of two nodes.
Basically, most of the work has already been done for WAL archiving. However, to make it easy for you I will explain 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 (note that some of them are already default in PostgreSQL 10.0):
wal_level = replicamax_wal_senders = 5 # or whatever value >= 2 hot_standby = on # already a sophistication
Just like previously, the wal_level variable has to be adjusted to ensure ...