* Fix PostgreSQL query performance for large datasets.
* Allow repositories on versioned storage to be read at a target time.
* Allow requested standby backup to proceed with no standby.
* Summarize backup reference list for info command text output.
* Refresh web-id token for each S3 authentication.
* Correctly display current values for indexed options in help.
* Save backup.info only when contents have changed.
* Remove limitation on reading files in parallel during restore.
* Improve SFTP error messages.
* Add performance tuning section to user guide.
* Documentation improvements
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=77
- update to version 2.53
* IMPORTANT NOTE: The log-level-stderr option default has been changed from warn to off.
This makes it easier to capture errors when only redirecting stdout.
To preserve the prior behavior set log-level-stderr=warn
* Fixed SFTP renaming failure when file already exists
* Allow backups to run concurrently on different repositories
* Support IP-based SANs for TLS certificate validation.
* Default log-level-stderr option to off
* Allow alternative WAL segment sizes for PostgreSQL ≤ 10
* Add hint to check SFTP authorization log
* Documentation Improvements: Clarify archive-push multi-repo behavior
OBS-URL: https://build.opensuse.org/request/show/1189224
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=73
- update to version 2.51
* Bug Fixes:
+ Skip zero-length files for block incremental delta restore.
+ Fix performance regression in storage list.
+ Fix progress logging when file size changes during backup.
* Improvements:
+ Improved support for dual stack connections.
+ Make meson the primary build system.
+ Detect files that have not changed during non-delta incremental backup.
+ Prevent invalid recovery when backup_label removed.
+ Improve archive-push WAL segment queue handling.
+ Limit resume functionality to full backups.
+ Update resume functionality for block incremental.
+ Allow --version and --help for version and help.
+ Add detailed backtrace to autoconf/make build.
* Documentation Improvements:
+ Update references to recovery.conf. (Reviewed by Stefan Fercot. Suggested by Stephen Frost.)
OBS-URL: https://build.opensuse.org/request/show/1163486
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=67
- update to version 2.48
* Bug Fixes:
+ Fix issue restoring block incremental without a block list.
+ [doc] Fix configuration reference example for the tls-server-address option.
+ [doc] Fix command reference example for the filter option.
* Features:
+ Add --repo-storage-tag option to create object tags.
+ Add known hosts checking for SFTP storage driver.
+ Support for dual stack connections.
+ Add backup size completed/total to info command JSON output.
* Improvements:
+ Multi-stanza check command.
+ Retry reads of pg_control until checksum is valid.
+ Optimize WAL segment check after successful backup.
+ Improve GCS multi-part performance.
+ Allow archive-get command to run when stanza is stopped.
+ Accept leading tilde in paths for SFTP public/private keys.
+ Reload GCS credentials before renewing authentication token.
* Test Suite Improvements
- refreshed patches; release.xml has been splitted into individual files
OBS-URL: https://build.opensuse.org/request/show/1113999
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=61
- update to version 2.47
* Bug Fixes:
+ Preserve block incremental info in manifest during delta backup
+ Fix block incremental file names in verify command
+ Fix spurious automatic delta backup on backup from standby
+ Skip recovery.signal for PostgreSQL >= 12 when recovery type=none
+ Fix unique label generation for diff/incr backup
+ Fix time-based archive expiration when no backups are expired
* Improvements:
+ Improve performance of SFTP storage driver
+ Add timezone offset to info command date/time output
+ Centralize error handling for unsupported features
* Documentation Improvements:
+ Clarify preference to install from packages in the user guide
OBS-URL: https://build.opensuse.org/request/show/1102632
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=59
- update to version 2.46
* Features:
+ Block incremental backup. (Reviewed by John Morris, Stephen Frost, Stefan Fercot.)
+ SFTP support for repository storage. (Contributed by Reid Thompson. Reviewed by Stephen Frost, David Steele.)
+ PostgreSQL 16 support. (Reviewed by Stefan Fercot.)
* Improvements:
+ Allow page header checks to be skipped. (Reviewed by David Christensen. Suggested by David Christensen.)
+ Avoid chown() on recovery files during restore. (Reviewed by Stefan Fercot, Marcelo Henrique Neppel. Suggested by Marcelo Henrique Neppel.)
+ Add error retry detail for HTTP retries.
* Documentation Improvements:
+ Add warning about using recovery type=none. (Reviewed by Stefan Fercot.)
+ Add note about running stanza-create on already-created repositories.
OBS-URL: https://build.opensuse.org/request/show/1089458
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=57
- update to version 2.43
+ Bug Fixes:
- Fix missing reference in diff/incr backup.
+ Improvements:
- Add hint when an option is specified without an index.
- update to version 2.42
+ Bug Fixes:
- Fix memory leak in file bundle backup/restore.
- Fix protocol error on short read of remote file.
+ Improvements:
- Do not store references for zero-length files when bundling.
- Use more generic descriptions for pg_start_backup()/pg_stop_backup().
OBS-URL: https://build.opensuse.org/request/show/1040869
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=51
- update do version 2.39
+ Bug Fixes:
- Fix error thrown from FINALLY() causing an infinite loop.
- Error on all lock failures except another process holding the lock.
+ Features:
- Backup file bundling for improved small file support.
- Verify command to validate the contents of a repository.
- PostgreSQL 15 support.
- Show backup percent complete in info output.
- Auto-select backup for restore command --type=lsn.
- Suppress existing WAL warning when archive-mode-check is disabled.
- Add AWS IMDSv2 support.
+ Improvements:
- Allow repo-hardlink option to be changed after full backup.
- Increase precision of percent complete logging for backup and restore.
- Improve path validation for repo-* commands.
- Improve stop command to honor stanza option.
- Improve error message for invalid repo-azure-key.
- Add hint to check the log on archive-get/archive-push async error.
- Add ClockError for unexpected clock skew and timezone changes.
- Strip extensions from history manifest before showing in error message.
- Add user:group to lock permission error.
+ Documentation Bug Fixes:
- Fix incorrect reference to stanza-update in the user guide.
- Fix example for repo-gcs-key-type option in configuration reference.
- Fix tls-server-auth example and add clarifications.
+ Documentation Improvements:
- Simplify messaging around supported versions in the documentation.
- Add option type descriptions.
- Add FAQ about backup types and restore speed.
OBS-URL: https://build.opensuse.org/request/show/985710
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=48
- diff/full/incremental backup
- pgbackrest services for the TLS server
- add pgbackrest.target to restart/stop all sub services
- add Requires(pre) for postgresql-server to make sure the
postgresql user is available for file permissions
- change permissions of the config file from 0644 to 0640 as the
file can contain passwords and encryption keys.
- modernize the spec file
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=43
- update to version 2.36
+ Bug Fixes:
- Allow "global" as a stanza prefix.
- Fix segfault on invalid GCS key file.
+ Improvements:
- Allow link-map option to create new links.
- Increase max index allowed for pg/repo options to 256.
- Add WebIdentity authentication for AWS S3.
- Report backup file validation errors in backup.info.
- Add recovery start time to online backup restore log.
- Report original error and retries on local job failure.
- Rename page checksum error to error list in info text output.
- Add hints to standby replay timeout message.
- update to version 2.35 Binary protocol
** IMPORTANT NOTE **: The log level for copied files in the
backup/restore commands has been changed to detail. This makes
the info log level less noisy but if these messages are required
then set the log level for the backup/restore commands to detail.
+ Bug Fixes:
- Detect errors in S3 multi-part upload finalize.
- Fix detection of circular symlinks.
- Only pass selected repo options to the remote.
+ Improvements:
- Binary protocol.
- Automatically create data directory on restore.
- Allow restore --type=lsn.
- Change level of backup/restore copied file logging to detail.
- Loop while waiting for checkpoint LSN to reach replay LSN.
- Log backup file total and restore size/file total.
+ Documentation Bug Fixes:
OBS-URL: https://build.opensuse.org/request/show/935686
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=40
- update to version 2.34 with Postgresql-14 support
+ Bug Fixes:
- Fix issues with leftover spool files from a prior restore.
- Fix issue when checking links for large numbers of tablespaces.
- Free no longer needed remotes so they do not timeout during restore.
- Fix help when a valid option is invalid for the specified command.
+ Features:
- Add PostgreSQL 14 support.
- Add automatic GCS authentication for GCE instances.
- Add repo-retention-history option to expire backup history.
- Add db-exclude option.
+ Improvements:
- Change archive expiration logging from detail to info level.
- Remove stanza archive spool path on restore.
- Do not write files atomically or sync paths during backup copy.
+ Documentation Improvements:
- Update contributing documentation.
- Clarify that repo-s3-role is not an ARN.
OBS-URL: https://build.opensuse.org/request/show/908629
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=39
- update to version 2.31
+ Bug Fixes:
- Allow [, #, and space as the first character in database names.
- Create standby.signal only on PostgreSQL 12 when restore type
is standby.
+ Features:
- Expire history files.
- Report page checksum errors in info command text output.
- Add repo-azure-endpoint option.
- Add pg-database option.
+ Improvements:
- Improve info command output when a stanza is specified but
missing.
- Improve performance of large file lists in backup/restore
commands.
- Add retries to PostgreSQL sleep when starting a backup.
+ Documentation Improvements:
Replace RHEL/CentOS 6 documentation with RHEL/CentOS 8.
OBS-URL: https://build.opensuse.org/request/show/858765
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=36
- update to version 2.30
+ Bug Fixes:
- Error with hints when backup user cannot read pg_settings.
+ Features:
- PostgreSQL 13 support.
+ Improvements:
- Improve PostgreSQL version identification.
- Improve working directory error message.
- Add hint about starting the stanza when WAL segment not found.
- Add hint for protocol version mismatch.
+ Documentation Improvements:
Add note that pgBackRest versions must match when running remotely.
Move info command text to the reference and link to user guide.
Update yum repository path for CentOS/RHEL user guide.
- Packaging
+ Remove non needed perl_requires
+ Allow build on i586 as source are now 100% C
OBS-URL: https://build.opensuse.org/request/show/841600
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=35
- update to version 2.29 - Auto S3 Credentials on AWS
+ Bug Fixes:
- Suppress errors when closing local/remote processes. Since the
command has completed it is counterproductive to throw an
error but still warn to indicate that something unusual happened.
- Fix issue with = character in file or database names.
+ Features:
- Automatically retrieve temporary S3 credentials on AWS instances.
- Add archive-mode option to disable archiving on restore.
+ Improvements:
- PostgreSQL 13 beta3 support. Changes to the control/catalog/WAL
versions in subsequent betas may break compatibility but
pgBackRest will be updated with each release to keep pace.
- Asynchronous list/remove for S3/Azure storage.
- Improve memory usage of unlogged relation detection in
manifest build.
- Proactively close file descriptors after forking async process.
- Delay backup remote connection close until after archive check.
- Improve detailed error output.
- Improve TLS error reporting.
+ Additional Notes
- Documentation Bug Fixes:
Add none to compress-type option reference and fix example.
Add missing azure type in repo-type option reference.
Fix typo in repo-cipher-type option reference.
- Documentation Improvements:
Clarify that expire must be run regularly when expire-auto
is disabled.
OBS-URL: https://build.opensuse.org/request/show/833420
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=34
- update to version 2.28 - Azure Repository Storage
+ Bug Fixes:
- Fix restore --force acting like --force --delta. This caused
restore to replace files based on timestamp and size rather
than overwriting, which meant some files that should have been
updated were left unchanged. Normal restore and restore
--delta were not affected by this issue.
+ Features:
- Azure support for repository storage.
- Add expire-auto option. This allows automatic expiration
after a successful backup to be disabled.
+ Improvements:
- Asynchronous S3 multipart upload.
- Automatic retry for backup, restore, archive-get, and archive-push.
- Disable query parallelism in PostgreSQL sessions used for backup control.
- PostgreSQL 13 beta2 support. Changes to the control/catalog/WAL
versions in subsequent betas may break compatibility but
pgBackRest will be updated with each release to keep pace.
- Improve handling of invalid HTTP response status.
- Improve error when pg1-path option missing for archive-get command.
- Add hint when checksum delta is enabled after a timeline switch.
- Use PostgreSQL instead of postmaster where appropriate.
+ Documentation Bug Fixes:
- Fix incorrect example for repo-retention-full-type option.
- Remove internal commands from HTML and man command references.
+ Documentation Improvements:
- Update PostgreSQL versions used to build user guides. Also add
version ranges to indicate that a user guide is accurate for a
range of PostgreSQL versions even if it was built for a
specific version.
OBS-URL: https://build.opensuse.org/request/show/828501
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=33