PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

We need to cover a few different scenarios here. One of the things we want to do is transfer files from one server to another. A popular way to do this is with the rsync command. On Debian or Ubuntu systems, we can install it as a root-capable user this way:

sudo apt-get install rsync

There's also a neat trick we can use to simplify the transferring of files to the WAL archive system. Create a file named /etc/rsyncd.conf and fill it with this content, assuming /db/wal_archive is where we want to send files:

[archive] 
    path = /db/wal_archive 
    comment = Archived Transaction Logs 
    uid = postgres 
    gid = postgres 
    read only = true

We're now ready to protect our data from hardware problems.