* 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
+ Bug Fixes:
- Fix issue checking if file links are contained in path links.
- Allow pg-path1 to be optional for synchronous archive-push.
- The expire command now checks if a stop file is present.
- Handle missing reason phrase in HTTP response.
- Increase buffer size for lz4 compression flush.
- Ignore pg-host* and repo-host* options for the remote command.
- Fix possibly missing pg1-* options for the remote command.
+ Features:
- Time-based retention for full backups.
The --repo-retention-full-type option allows retention of full
backups based on a time period, specified in days.
- Ad hoc backup expiration. Allow the user to remove a specified
backup regardless of retention settings.
- Zstandard compression support. Note that setting compress-type=zst
will make new backups and archive incompatible (unrestorable)
with prior versions of pgBackRest.
- bzip2 compression support. Note that setting compress-type=bz2
will make new backups and archive incompatible (unrestorable)
with prior versions of pgBackRest.
- Add backup/expire running status to the info command.
+ Improvements:
- Expire WAL archive only when repo-retention-archive threshold
is met. WAL prior to the first full backup was previously
expired after the first full backup. Now it is preserved
according to retention settings.
- Add local MD5 implementation so S3 works when FIPS is enabled.
- PostgreSQL 13 beta1 support. Changes to the control/catalog/WAL
versions in subsequent betas may break compatibility but
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=32
+ Bug Fix : Remove empty subexpression from manifest regular
expression. MacOS was not happy about this though other
platforms seemed to work fine.
+ Improvements:
- N on-blocking TLS implementation.
- Only limit backup copy size for WAL-logged files. The prior
behavior could possibly lead to postgresql.conf or
postgresql.auto.conf being truncated in the backup.
- TCP keep-alive options are configurable.
- Add io-timeout option.
- update to version 2.25 : LZ4 Compression Support
+ Features:
- Add lz4 compression support. Note that setting
compress-type=lz4 will make new backups and archive incompatible
(unrestorable) with prior versions of pgBackRest.
- Add --dry-run option to the expire command. Use dry-run to see
which backups/archive would be removed by the expire command
without actually removing anything.
+ Improvements:
- Improve performance of remote manifest build.
- Fix detection of keepalive options on Linux.
- Add configure host detection to set standards flags correctly.
- Remove compress/compress-level options from commands where unused.
- Limit backup file copy size to size reported at backup start.
If a file grows during the backup it will be reconstructed by
WAL replay during recovery so there is no need to copy the
additional data.
- Packaging:
+ Add new requirement lz4
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=31
- update to 2.24 version : Bugfix
+ Bug Fixes:
- Prevent defunct processes in asynchronous archive commands.
- Error when archive-get/archive-push/restore are not run on a
PostgreSQL host.
- Read HTTP content to eof when size/encoding not specified.
- Fix resume when the resumable backup was created by Perl. In
this case the resumable backup should be ignored, but the C
code was not able to load the partial manifest written by Perl
since the format differs slightly.
Add validations to catch this case and continue gracefully.
+ Features:
- Auto-select backup set on restore when time target is specified.
Auto-selection is performed only when --set is not specified.
If a backup set for the given target time cannot not be found,
the latest (default) backup set will be used.
+ Improvements:
- Skip pg_internal.init temp file during backup.
- Add more validations to the manifest on backup.
+ Documentation Improvements:
- Prevent lock-bot from adding comments to locked issues.
- Packaging
+ use %autopatch
+ use a normalized name for source %name-%version.tar.gz
+ spec cleaning
+ Refresh patch libpq-fe.h_localisation.patch
+ Delete merged upstream_wrongly_bring_back_pg_config.patch
OBS-URL: https://build.opensuse.org/request/show/787841
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=30
+ Bug Fixes:
- Fix missing files corrupting the manifest. If a file was
removed by PostgreSQL during the backup (or was missing from
the standby) then the next file might not be copied and updated
in the manifest. If this happened then the backup would error
when restored.
+ Improvements:
- Use pkg-config instead of xml2-config for libxml2 build options.
- Validate checksums are set in the manifest on backup/restore.
- Introduce upstream_wrongly_bring_back_pg_config.patch to fix
upstream code (using pg_config in client code)
Upstream issue #920
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgbackrest?expand=0&rev=29
