PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

We will need one new server for this procedure. The primary PostgreSQL server will remain pg-primary, but we need a target server for the restore. This server will be named pg-clone. Make sure to have the password for the postgres system user on this server. As usual, our database will be located at /db/pgdata:

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

• 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. On the pg-clone server as the postgres user, execute the following command for direct SSH access to pg-primary as the postgres user:

ssh-copy-id postgres@pg-primary 

3. Ensure that ...