Skip to main content
Version Next

WAL Archiving Configuration

This section explains how to configure a PostgreSQL database instance to enable the archiving of transaction logs WAL - Write-Ahead Logging.

To perform backups on a running cluster, WAL archiving must be enabled. At least one WAL segment will be created during the backup, even if no explicit write is performed on the cluster.

note

After completing the configuration, restart the PostgreSQL instance before running any backup operations.

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 Arquivamento de Wal section using the [Space] key.

  3. Select the Backup Site.

  4. Confirm the instance restart. This step is required to apply the PostgreSQL configuration changes.

  5. Enter the PostgreSQL major version.

  6. Confirm the activation of automatic archiving for transaction logs (WAL).

  7. Confirm whether you want to add additional database instances to the backup site.

    Figure 1 - WAL Archiving
    Figure 1 - WAL Archiving