•  
News
pg_probackup 2.3.0 has been released
A new version of pg_probackup, a backup tool developed by Postgres Pro team, has been released. It is available on github and in the next Postgres Pro release.
New features:
- The
--status
option can be used with thedelete
command to remove all backups with the specified status. - The
--no-sync
flag can be used withbackup
,restore
, andarchive-push
commands to disable syncing of copied files to the underlying storage. - The
--note
option allows to add a text note of size up to 1KB to the backup metadata when runningbackup
andset-backup
commands. - Multi-timeline incremental chains are now supported. The timeline number of an incremental backup can differ from the parent timeline number, but only if it is possible to determine (using WAL archive) that the child timeline descends from the parent timeline.
- You can now set PostgreSQL parameters
primary_slot_name
andprimary_conninfo
during restore using the-S | --primary-slot-name
and--primary-conninfo
options, respectively. - Major revamp of the
archive-push
command:- Multi-threading support is added via the
-j | --threads
option. - Batch processing is added via the
--batch-size
option. - In the remote mode, checksums are now computed on a remote agent.
- Multi-threading support is added via the
- Major revamp of the
archive-get
command:- Multi-threading support is added via the
-j | --threads
option. - WAL prefetching is added via the
--batch-size
option. The default location of the prefetched WAL segments isPGDATA/pg_wal/pbk_prefetch
. The location can be changed using the--prefetch-dir
option. - Partial WAL files produced by
pg_receivewal
program are now recognized and used if the corresponding full WAL segment is missing.
- Multi-threading support is added via the
Improvements:
- The speed of restore from incremental chain is greatly improved. In some cases, by an order of magnitude.
- The speed of
merge
, especially merge of several backups at a time, is greatly improved. - The speed of remote backup in PAGE and PTRACK modes is greatly improved.
- You can now delete a backup even if there is no space left on device.
- Hidden files are now ignored during backup.
- Now it is explicitly forbidden to restore a backup using an older pg_probackup version.
Bug fixes:
- Enabled logging info file should not break archiving anymore.
- The
add-instance
command no longer implicitly sets the--remote-proto
and--remote-host
parameters in the instance configuration when adding a remote PostgreSQL instance into the backup catalog. - When taking a backup in the ARCHIVE mode, pg_probackup now waits for the segment containing the START LSN, not the previous segment.
- The
expire-time
attribute is now inherited during merge. - Setting session parameters via the
PGOPTIONS
environment variable during backup now does not cause corruption of backup meta information.