Skip to main content
Version 4.0.0

Backup Site Configuration via PgSmart Web

In this option, it is possible to define the base directory of the database where the PostgreSQL cluster is located.

During backups, the provided path will be compared with the data directory of the running instance. If they are different, the backup will be interrupted with an error.

By default, in RHEL 7 and 8, clusters are stored in: /var/lib/pgsql/[version]/data.

Prerequisites

  1. Select the desired Environment from the dropdown in the top bar.

  2. Select the Backup option in the side menu. If there are registered backups, cards for each registered backup in the selected environment will be displayed.

  3. Select the backup for which you want to configure the Sites.

  4. Select the Sites tab. The backup sites with their respective parameters will be displayed.

    Figure 1 - Backup Site Configuration - Selecting the Option
    Figure 1 - Backup Site Configuration - Selecting the Option

Insert a New Site​

  1. To insert a new site: 1.1. Click on Incluir. 1.2. Enter a name for the site. 1.3. Click on Avançar. 1.4. Enter the Site Instances data. (Select "New Instance" to add other instances.) 1.4.1. Enter the host or IP connection of the PostgreSQL instance. 1.4.2. Enter the SSH connection port for the PostgreSQL instance. 1.4.3. Enter the SSH connection user for the PostgreSQL instance. 1.4.4. Enter the connection port for the PostgreSQL instance. 1.4.5. Enter the data directory of the database instance. 1.4.6. Enter the connection user for the PostgreSQL instance.

    note

    You can add more database instances to the site. To do so, confirm this option and provide the requested data for the new instance.

    1.5. Click on Concluir.

    Figure 2a - Backup Site Configuration - Inserting Site
    Figure 2a - Backup Site Configuration - Inserting Site
    Figure 2b - Backup Site Configuration - Site Identification
    Figure 2b - Backup Site Configuration - Site Identification
    Figure 2c - Backup Site Configuration - Inserting Site Data
    Figure 2c - Backup Site Configuration - Inserting Site Data

Activate a Site​

  1. To Activate a backup site: 1.1. Click on the three dots (⋮) next to the site you wish to activate. 1.2. Click Ativar Site. 1.3. Confirm if the WAL archiving for the database instances is configured for the site. 1.4. If No: 1.4.1. Confirm the activation of WAL archiving. 1.4.2. Confirm the restart of the instance so that WAL archiving takes effect.

    Figure 3 - Backup Site Configuration - Activate Site - Selecting the Option
    Figure 3 - Backup Site Configuration - Activate Site - Selecting the Option
    Figure 4 - Backup Site Configuration - Activate Site - Confirming WAL Archiving
    Figure 4 - Backup Site Configuration - Activate Site - Confirming WAL Archiving
    Figure 5 - Backup Site Configuration - Activate Site - Activating WAL Archiving
    Figure 5 - Backup Site Configuration - Activate Site - Activating WAL Archiving
    Figure 6 - Backup Site Configuration - Activate Site - Restarting the Instance
    Figure 6 - Backup Site Configuration - Activate Site - Restarting the Instance

Remove a Site​

  1. To Remove a backup site: 1.1. Click on the three dots (⋮) next to the site you wish to remove. 1.2. Click Remover Site.

    Figure 7 - Backup Site Configuration - Remove Site
    Figure 7 - Backup Site Configuration - Remove Site

Add Site Parameters​

  1. Add Parameters to the site. 1.1. Click on the three dots (⋮) next to the site for which you want to configure parameters. 1.2. Configure the desired parameter. 1.3. Click on Incluir.

    Figure 8 - Backup Site Configuration - Add Parameter
    Figure 8 - Backup Site Configuration - Add Parameter
    Figure 9 - Backup Site Configuration - Including Parameter Configuration
    Figure 9 - Backup Site Configuration - Including Parameter Configuration