PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Our archive server has a 3 TB mount at the /db directory and is named arc_server on our network. The PostgreSQL source server resides at pgha1. Follow these steps for long-term storage of important WAL files on an archive server:

1. Debian-based systems will need to modify the /etc/default/rsync file and change the RSYNC_ENABLE variable to true.
2. Create a directory to store archived WAL files as the postgres user with these commands:

sudo mkdir -p /db/pg_archived
sudo chown postgres:postgres /db/pg_archived

3. Create a file named /etc/rsyncd.conf and fill it with the following contents:

[wal_store] path = /db/pg_archived comment = DB WAL Archives uid = postgres gid = postgres read only = false hosts allow = pgha1 hosts deny = ...