Software 42179 Published by

The latest version of pgBackRest, an intuitive backup and restore solution for PostgreSQL that can easily scale up to the largest databases and workloads, is available.

pgBackRest 2.46 Released

  Crunchy Data is pleased to announce the release of  pgBackRest 2.46, the latest version of the reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads.

Over the last year pgBackRest has introduced many exciting new features including block incremental backup, file bundling, repository verification, backup annotations, and SFTP repository storage.

IMPORTANT NOTE: pgBackRest 2.44 is the last version to support PostgreSQL 9.0/9.1/9.2.

pgBackRest supports a robust set of features for managing your backup and recovery infrastructure, including: parallel backup/restore, full/differential/incremental backups, block incremental backup, multiple repositories, delta restore, parallel asynchronous archiving, per-file checksums, page checksums (when enabled) validated during backup, multiple compression types, encryption, partial/failed backup resume, backup from standby, tablespace and link support, S3/Azure/GCS/SFTP support, backup expiration, local/remote operation via SSH or TLS, flexible configuration, and more.

pgBackRest can be installed from the  PostgreSQL Yum Repository or the  PostgreSQL APT Repository. Source code can be downloaded from  releases.

Major New Features

Block Incremental Backup

Block incremental backup saves space in the repository by only storing file parts that have changed since the prior backup. In addition to space savings, this feature makes backup faster since there is less data to compress and transfer. Delta restore is also improved because less data from the repository is required to restore files. See  User Guide and  pgBackRest File Bundling and Block Incremental Backup.

File Bundling

File bundling combines smaller files to improve the efficiency of repository reads and writes, especially on object stores such as S3, Azure, and GCS. Zero-length files are stored only in the manifest. See  User Guide and  pgBackRest File Bundling and Block Incremental Backup.


The verify command checks that files in the repository have not been lost or corrupted and generates a report when problems are found. See  Command Reference.

Backup Key/Value Annotations

Backup annotations allow custom annotations to be stored with a backup and queried with the info command. See  User Guide.

SFTP Repository Storage

Repositories can now be stored on an SFTP server. See  User Guide.

pgBackRest 2.46 Released