Mastering PostgreSQL 9.6

Performing a basic setup

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:

wal_level = replica max_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 that PostgreSQL produces enough transaction logs to sustain ...