Skip to main content
Version 3.1.0

Backup Repositories Configuration

note

In this option, it is possible to define the location where the metadata of the backups, the backups themselves, and the transactional logs that will enable future restoration will be stored.

The Backup Repository is, in practice, a copy of the instance directory (PGDATA) plus the transactional logs (which ensure the consistency of the backups). More than one repository for each backup is possible, and these can be "distributed" across other servers.

Command Syntax
Terminal input
pgsmart backup config [Flags]

Flags:

  • -h, --help. => Help
Non-Interactive Configuration

Non-interactive execution is disabled for this operation.

Interactive Configuration
  1. Select the PgSmart Agent (or register new Agent).

  2. Select the Backup Repository section (selection is made with the [spaces] key).

Upon selecting the Backup Repositories section, the following operations are made available:

  • List backup repositoriess.
  • Add a Backup Repository.
  • Edit a Backup Repository.
  • Remove a Backup Repository.

List the Backup Repositories

  1. Select the List operation.

  2. The configured backup repositories will be displayed.

    Figure 1 - Backup Repo Configuration - List
    Figure 1 - Backup Repo Configuration - List

Add a Backup Repository

  1. Select the Add operation.

  2. Enter the Full Path to the Backup Repository (Default: /var/lib/pgBackRest)

  3. Confirm whether you want to set the retention period for backups in this repository.

    3.1 Select the method to define the retention period (either in days or by maximum quantity).

    3.2 Specify the maximum number of days or backups for the expiration of full backups.

    3.3 Specify the maximum quantity for retaining "differential" backups.

  4. Confirm the addition of the backup repository.

    Figure 2 - Backup Repo Configuration - Cria
    Figure 2 - Backup Repo Configuration - Cria

Edit a Backup Repository

  1. Select the Edit operation.

  2. Enter the Full Path to the Backup Repository (Default: /var/lib/pgBackRest)

  3. Confirm whether you want to set the retention period for backups in this repository.

    3.1 Select the method to define the retention period (either in days or by maximum quantity).

    3.2 Specify the maximum number of days or backups for the expiration of full backups.

    3.3 Specify the maximum quantity for retaining "differential" backups.

  4. Confirm the edition of the backup repository.

    Figure 3 - Backup Repo Configuration - Cria
    Figure 3 - Backup Repo Configuration - Cria

Remove a Backup Repository

  1. Select the Remove operation.

  2. Select the Repository you wish to remove.

  3. Confirm the removal of the repository.

    Figure 4 - Backup Repository - Remove
    Figure 4 - Backup Repository - Remove
Final Notes
note
  • By default, backups will be performed for all registered repositories. Currently, PgSmart does not support directing backups to a specific repository, although this functionality is supported by the pgBackRest component.

  • This operation will be made available shortly.

  • To perform this operation in PostgreSYS, use the "Global Settings" section, where access is given to all pgBackRest parameters, making it possible to create and configure a specific parameter to indicate the target repository (this option requires more specific knowledge of pgBackRest and more details can be obtained in the pgBackRest component documentation).