How PostgreSQL WAL Files Backup Works
To maintain integrity and data consistency, Veeam Backup & Replication makes a backup of write ahead log (WAL) files that contain PostgreSQL instance logs. Veeam Backup & Replication uses these log files for instance recovery operations.
To back up WAL files, you must enable application-aware processing for PostgreSQL VMs. After this, during the job session Veeam Backup & Replication installs non-persistent runtime components or uses (if necessary, installs) persistent agent components on this VM to collect information about the instance and process WAL files according to job settings. For more information on how to configure application-specific settings for PostgreSQL WAL files backup, see PostgreSQL WAL Settings step of the backup job wizard — you can specify how logs should be backed up and\or deleted for PostgreSQL instances.
The WAL files backup for PostgreSQL VMs is performed in the following way:
- Veeam Backup & Replication launches the parent backup job by schedule.
- The parent backup job creates an image-level backup of the PostgreSQL VM and stores this backup to the backup repository.
- A child job starts to back up WALs: Veeam Backup & Replication accesses the PostgreSQL VM guest OS over SSH. By default, Veeam Backup & Replication installs non-persistent components to the VM guest OS, and Veeam Backup & Replication will uninstall them after the job completes. You can also install a Linux management agent to the VM guest OS — in this case, the agent will remain installed on the VM and Veeam Backup & Replication will use it to access the VM guest OS. For more information, see Persistent Agent Components.
- Veeam Backup & Replication scans the PostgreSQL system and gets information that is necessary to back up backup and restore a PostgreSQL instance.
- List of all databases added to the instance.
- The instance state — if the instance is on or off, in which logging mode it runs.
- Paths to all Instance files (configuration logs and so on) and other data required for backup.
- The non-persistent runtime components or persistent agent components copy WALs from the log archive destination (set by the PostgreSQL administrator) to a temporary directory on the VM guest file system.
- Veeam Backup & Replication maps information about the PostgreSQL system collected at the step 4 with information kept in the configuration database. This periodic mapping helps to reveal instances for which Veeam Backup & Replication must ship WALs to the backup repository during this time interval.
- Veeam Backup & Replication transfers WALs from the temporary location on the PostgreSQL VM to the backup repository and saves them as VLB files. Veeam Backup & Replication transfers WALs either directly or through the log shipping server. The source-side Veeam Data Mover compresses log data to be transferred according to its built-in settings. On the backup repository side, data is compressed according to the parent backup job settings.
- Veeam Backup & Replication deletes WALs from the temporary directory on the VM guest file system.
Consider the following: