Chapter 29. Installation and Configuration of Backup and Restore Tools
Table of Contents
Note
This instruction applies to any of the supported operating systems.
For simplicity, the example below uses a Debian-based distribution. If you are using a different OS, adjust the commands accordingly.
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:
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.
Configure a STREAM backup.
For more information, refer to the official Postgres Pro documentation on setting up STREAM backups.
pg_probackup provides the point-in-time recovery (PITR) feature. For PPEM to use PITR, complete the following steps:
Configure the installed pg_probackup as described above.
Configure continuous WAL archiving by editing the necessary parameters of the instance in one of the following ways:
(Recommended) By creating the special type of mass instance operation in the PPEM web application.
Manually by editing the instance parameters in the PPEM web application.
Manually by connecting directly to the server that hosts the instance and making the required changes.