Life with Open Source

commit   : 53a981ed5bbaa8344da88dfa3550e6cfb6ecf3c9    
  
author   : David Rowley <drowley@postgresql.org>    
date     : Mon, 24 Aug 2026 22:43:27 +1200    
  
committer: David Rowley <drowley@postgresql.org>    
date     : Mon, 24 Aug 2026 22:43:27 +1200    

This calculation was failing to correctly account for the min_value when  
calculating how many random members to add to the Bitmapset.  What the  
code was meant to do was add a random number of members between the  
minimum and maximum values.  The code failed to account for the minimum  
value being non-zero, which could result in too many members being added  
to the set, which could reduce the effectiveness of the test.  In reality,  
the only caller to this function did pass 0 as the min_value, so there is  
no live bug being fixed here.  
  
Fix this so that the Bitmapset is more sparsely populated with members  
between the minimum and maximum values.  In passing, swap the order of the  
min_value and max_value parameters.  Having the minimum value appear  
before the maximum value makes more sense.  Also align the names of both  
parameters, and adjust the 'offset' calculation to widen the offset range  
by 1 so that the possible range for that random value is -max_value to  
max_value.  
  
Author: David Rowley <dgrowleyml@gmail.com>  
Reviewed-by: Greg Burd <greg@burd.me>  
Discussion: https://postgr.es/m/CAApHDvpfZqdMRmR-6W9UXb+Tanex5wK6PsL=XzYCV4P3pD36Ng@mail.gmail.com  

commit   : 165aa5040a02e13011f07e3c6669ac0edf4f8258    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Sun, 23 Aug 2026 12:42:55 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Sun, 23 Aug 2026 12:42:55 -0400    

Commit 42473b3b3 implemented SupportRequestSimplifyAggref, but failed  
to think about what infrastructure would be required for an extension  
to use that: there is no SQL-level mechanism for attaching a planner  
support function to an aggregate.  That seems pretty critical for a  
feature that's primarily intended to be used by extensions.  
  
To fix, add a SUPPORT clause to CREATE AGGREGATE, and teach pg_dump  
(and thereby pg_upgrade) about dumping this aggregate property.  
We don't need to touch ALTER AGGREGATE, because it's already the case  
that you're supposed to use CREATE OR REPLACE AGGREGATE if you want  
to alter any aggregate-specific properties set by CREATE AGGREGATE.  
(Maybe at some point we'll think that that policy ought to change,  
but I don't think this one feature moves the needle enough.)  
  
Per report from Andrei Lepikhov, who also provided some of the  
new documentation text.  
  
Reported-by: Andrei Lepikhov <lepihov@gmail.com>  
Author: Tom Lane <tgl@sss.pgh.pa.us>  
Reviewed-by: Andrei Lepikhov <lepihov@gmail.com>  
Discussion: https://postgr.es/m/8f58c96d-d3c7-4c0f-9898-116f00eeaff6@gmail.com  
Backpatch-through: 19  

commit   : 8c8f3ee63e310f0b3ea10b55ed3b96b4cc9296da    
  
author   : David Steele <david@pgbackrest.org>    
date     : Mon, 17 Aug 2026 16:08:40 +0700    
  
committer: David Steele <david@pgbackrest.org>    
date     : Mon, 17 Aug 2026 16:08:40 +0700    

Bug Fixes:  
  
* Fix hang when the chunk buffer is smaller than the input buffer. (Reviewed by Andrew Pogrebnoi, Douglas J Hunley. Reported by crajac66.)  
* Compare a new backup label only against its own full backup set. (Reviewed by Douglas J Hunley. Reported by Anton Glushakov.)  
* Fix source archives generated by GitHub missing files required to build. (Reported by aardvarkzed.)  
  
Features:  
  
* PostgreSQL 19beta3 support. (Contributed by Lardière Sébastien. Reviewed by David Steele.)  
  
Documentation Improvements:  
  
* Document exception for dots in S3 bucket names when repo-s3-uri-style=path.  
* Remove explicit hot_standby configuration from user guide.  

commit   : 724edf9bde9d356724ad384a2e196edc3c9f80f7    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 11 Aug 2026 14:38:31 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 11 Aug 2026 14:38:31 -0400    

commit   : 841d0cb0f9b8b1b25e7b299ac0eb134074b45a08    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 11 Aug 2026 14:37:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 11 Aug 2026 14:37:01 -0400    

commit   : 6b3806732b7c5df06bdd0ed150e8a07b4ad62315    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:59:18 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:59:18 -0400    

commit   : 18ec528b8c3804f4c101e3a8d091ada7c5a40bb4    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:49 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:49 -0400    

commit   : 2ff1375b5dd8bf09d8cb0e795974528180fd75ca    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:57:41 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:57:41 -0400    

commit   : 492b517f362a4325bbcd6c1aa6f1204b7696d7ed    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    

commit   : 7d3e000c5961a544302072058a1184e9a588837b    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:56:00 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:56:00 -0400    

commit   : a5c8e521cf9e2d2334cf3c94ed64edb397b00e01    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    

commit   : 083ac033419f690758508e08c1736089384bbee8    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:54:09 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 16:54:09 -0400    

commit   : 83bb18b714e7b98c243083d2480828331601de23    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Aug 2026 12:35:48 -0400    

commit   : f84c8357d49ea9452cd606531e9c4c322c41bc2e    
  
author   : David Steele <david@pgbackrest.org>    
date     : Mon, 20 Jul 2026 15:13:35 +0700    
  
committer: GitHub <noreply@github.com>    
date     : Mon, 20 Jul 2026 15:13:35 +0700    

NOTE TO PACKAGERS: A new distribution tarball is available which simplifies the build process by providing pregenerated HTML documentation, man page, and code. The tarball is attached to each release as an asset and is named pgbackrest-{version}.tar.gz. See the README.md in the tarball for details. Please use the new distribution tarball to avoid the additional build tooling required to generate code in future releases.  
  
NOTE TO PACKAGERS: There is a new optional dependency on libsystemd.  
  
IMPORTANT NOTE: Starting with this release, only the restore command may be run as root by default. Use allow-root to run other commands as root (though this is not recommended).  
  
Bug Fixes:  
  
* Fix expire removing a backup in progress on another host. (Reviewed by Douglas J Hunley. Reported by Dmitrii.)  
* Fix archive-push-queue-max not enforced when a WAL file errors. (Reviewed by Stefan Fercot. Reported by vut12.)  
* Fix async archive-get failure during recovery across a timeline switch. (Reviewed by Douglas J Hunley. Reported by Jimmy Yih.)  
* Fix potential buffer overrun in error module. (Fixed by Christophe Pettus. Reviewed by David Steele.)  
* Fix use-after-free of parallel protocol client. (Reviewed by Douglas J Hunley. Reported by Georgy Shelkovy.)  
* Fix heap overflow when a pg option is set without pg1. (Reviewed by Douglas J Hunley. Reported by Naveen.)  
  
Features:  
  
* PostgreSQL 19beta2 support. (Reviewed by Stefan Fercot.)  
* Add archive-expire-before option to clean up WAL archive. (Contributed by Stefan Fercot. Reviewed by David Steele.)  
* Add batch delete for Azure storage. (Reviewed by Douglas J Hunley, Crispy.)  
* Add support for S3 Outposts. (Contributed by Shiva Kumar Ambigi. Reviewed by David Steele, Roberto Mello.)  
* Add S3 process authentication. (Reviewed by Andrew Charlton. Suggested by Andrew Charlton.)  
  
Improvements:  
  
* Reconnect SFTP storage after the server drops an idle connection. (Reviewed by Stefan Fercot. Suggested by mustafa0x, tisserat.)  
* Add user/group caching for faster manifest build. (Contributed by Gunnar Lindholm. Reviewed by David Steele.)  
* Add per-repo backup progress to info command output. (Contributed by Will Morland. Reviewed by David Steele, Stefan Fercot.)  
* Add backup.info checks to verify command. (Contributed by Denis Garsh. Reviewed by David Steele, Douglas J Hunley.)  
* Allow the S3 STS endpoint to be configured. (Contributed by Simon Gratton. Reviewed by David Steele.)  
* Add archive-push-batch-size to limit WAL pushed per asynchronous run. (Reviewed by Stefan Fercot.)  
* Exit async archive-push on first error. (Reviewed by Stefan Fercot. Suggested by Lardière Sébastien.)  
* Harden HTTP chunked response parsing. (Contributed by Shubham. Reviewed by David Steele.)  
* Error when running as root unless allow-root is enabled. (Reviewed by Douglas J Hunley.)  
* Fewer binary searches when building manifest. (Contributed by Gunnar Lindholm. Reviewed by David Steele.)  
* Improve seek performance during block incremental delta restore. (Reviewed by David Christensen, Douglas J Hunley.)  
* Bundle backup files in order rather than scanning for a better fit. (Reviewed by Stefan Fercot.)  
* Report the underlying error when a query fails to complete. (Reviewed by Andrew Pogrebnoi. Suggested by Marco Fontana.)  
* Report the actual error when an S3 credential request fails. (Reviewed by Douglas J Hunley. Suggested by Mitchell Grice.)  
* Report archive-push spool path errors to the PostgreSQL log. (Reviewed by Douglas J Hunley. Suggested by Don Seiler.)  
* Hint that pgBackRest may be out of date when a version is unsupported.  
* Add systemd notify integration. (Contributed by Andrew Jackson. Reviewed by David Steele.)  
* Suppress unused parameter errors in meson compiler probes. (Contributed by Jörg Plate. Reviewed by David Steele.)  
* C11 is now the minimum C standard. (Reviewed by Mohammad Ali Nazir Kosar.)  
  
Documentation Improvements:  
  
* Make stanza option internal for the repo-* commands. (Reviewed by Stefan Fercot.)  
* Document that info reads encryption settings from global section. (Reviewed by Stefan Fercot. Suggested by Ron Johnson.)  
* Document that expire-auto uses the backup command configuration. (Reviewed by Stefan Fercot. Suggested by Lardière Sébastien.)  
* Document adjusting the logrotate su directive for a dedicated user. (Reviewed by Douglas J Hunley. Suggested by lkanbus.)  
* Document that end-of-line comments are not supported in config files. (Reviewed by Douglas J Hunley. Suggested by Alex Richman.)  
  
Test Suite Improvements:  
  
* Fix Alpine group conflicts in CI containers. (Contributed by Artur Zakirov. Reviewed by David Steele.)

commit   : 4e1a23c0ea0be0214c6806baa212886cee8f14a6    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:51:39 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 15:51:39 -0400    

commit   : 93741c9db09709ebe05d5f59ee7852c3ad4981a9    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 11 May 2026 14:54:40 -0400