After taking a look at transaction log archiving and PITR we can focus our attention on one of the most widely used features in the PostgreSQL world today: streaming replication. The idea behind streaming replication is simple. After an initial base backup, the secondary can connect to the master and fetch transaction log in real time and apply it. Transaction log replay is not a single operation anymore, but rather a continuous process that is supposed to keep running as long as the cluster exists.
Setting up asynchronous replication
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...
