Skip to main content
Version 3.1.0

WAL Archiving Configuration

This section covers how to configure a PostgreSQL database instance to enable transaction log WAL - Write-Ahead Logging archiving.

To backup a running PostgreSQL cluster, it is essential that WAL archiving is enabled. At least one WAL segment will be created during the Backup, even if no explicit write is made to the cluster.

note

It is necessary to restart the PostgreSQL cluster after making these settings, before proceeding with any backup operation.

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 WAL Archiving Section using the [Space] key.

  3. Select the Backup Environment.

  4. Confirm the instance restart. This option is necessary for the PostgreSQL instance configuration parameter to be active.

  5. Select the Major version of environment PostgreSQL.

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

    Figure 1 - Wal Archiving
    Figure 1 - Wal Archiving