PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this procedure, we will need one server, our primary PostgreSQL server, which will be named pg-primary. As usual, our database is located at /db/pgdata.

Follow these steps to install and configure pgBackRest:

1. Install the pgBackRest toolkit as a root-capable user:

• For Red Hat-based servers, use the following command:

sudo yum install pgbackrest

• Debian-based systems should use this command instead:

sudo apt-get install pgbackrest

2. Modify /etc/pgbackrest.conf to reflect the following contents:

[main]pg1-path=/db/pgdata                                              [global]repo1-path=/var/lib/pgbackrestrepo1-retention-full=1start-fast=y

3. Ensure the following parameter is set in postgresql.conf:

archive_command = 'pgbackrest --stanza=main archive-push %p' 

4. If ...