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:

   • When configuring an instance on a server as described in the official Postgres Pro documentation.

   • When configuring an instance in the web application.

Example of the pg_probackup Installation Using APT

This section includes an example of pg_probackup installation on a server with a DBMS instance and PPEM.

The version of pg_probackup must correspond to the version of the instance. Version 16 is used in this example.

The installation process includes the following steps:

1. Start a new session under the superuser:

   $ sudo -s
   

2. To add the GPG key for the pg_probackup repository, install additional utilities:

   # apt install gpg wget
   # wget -qO - https://repo.postgrespro.ru/pg_probackup/keys/GPG-KEY-PG-PROBACKUP | \
   # tee /etc/apt/trusted.gpg.d/pg_probackup.asc
   

3. Configure the package repository:

   # . /etc/os-release
   # echo "deb [arch=amd64] https://repo.postgrespro.ru/pg_probackup/deb $VERSION_CODENAME  main-$VERSION_CODENAME " | tee /etc/apt/sources.list.d/pg_probackup.list
   

4. To make pg_probackup packages available for viewing and installing, update the package manager metadata:

   # apt update
   # apt search pg_probackup
   

5. Install pg_probackup:

   # apt install pg-probackup-16