Chapter 22. Installation and Configuration of Backup and Restore Tools

Table of Contents

22.1. Example of the pg_probackup Installation Using APT

PPEM performs backup using pg_probackup manually installed on all servers. The version of pg_probackup must correspond to the version of DBMS instances. The backup features available in PPEM depend on the pg_probackup edition.

For more information about installation, refer to the official Postgres Pro documentation on pg_probackup. It is also recommended to view the example of the pg_probackup installation using APT (for Debian-based operating systems).

After pg_probackup is installed, the agent automatically detects it and notifies the manager. The server is now ready for backup operations.

You must manually configure the installed pg_probackup. The configuration process includes the following steps on all servers:

  1. Create dedicated DBMS users and grant them backup privileges using pg_probackup.

    For more information, refer to the official Postgres Pro documentation on configuring the database cluster.

  2. Configure a STREAM backup.

    For more information, refer to the official Postgres Pro documentation on setting up STREAM backups.

  3. To provide point-in-time recovery (PITR), configure continuous WAL archiving in one of the following ways: