Add range_minus_multi and multirange_minus_multi functions
commit : 5eed8ce50ce9df1067b95593dde9f4fc526dfc72
author : Peter Eisentraut <peter@eisentraut.org>
date : Sat, 22 Nov 2025 09:40:00 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Sat, 22 Nov 2025 09:40:00 +0100
Click here for diff
The existing range_minus function raises an exception when the range is
"split", because then the result can't be represented by a single range.
For example '[0,10)'::int4range - '[4,5)' would be '[0,4)' and '[5,10)'.
This commit adds new set-returning functions so that callers can get
results even in the case of splits. There is no risk of an exception for
multiranges, but a set-returning function lets us handle them the same
way we handle ranges.
Both functions return zero results if the subtraction would give an
empty range/multirange.
The main use-case for these functions is to implement UPDATE/DELETE FOR
PORTION OF, which must compute the application-time of "temporal
leftovers": the part of history in an updated/deleted row that was not
changed. To preserve the untouched history, we will implicitly insert
one record for each result returned by range/multirange_minus_multi.
Using a set-returning function will also let us support user-defined
types for application-time update/delete in the future.
Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/ec498c3d-5f2b-48ec-b989-5561c8aa2024%40illuminatedcomputing.com
M doc/src/sgml/func/func-range.sgml
M src/backend/utils/adt/multirangetypes.c
M src/backend/utils/adt/rangetypes.c
M src/include/catalog/catversion.h
M src/include/catalog/pg_proc.dat
M src/include/utils/rangetypes.h
M src/test/regress/expected/multirangetypes.out
M src/test/regress/expected/rangetypes.out
M src/test/regress/sql/multirangetypes.sql
M src/test/regress/sql/rangetypes.sql
jit: Adjust AArch64-only code for LLVM 21.
commit : 912cfa3146ce4891671c34207177fd36bd155c09
author : Thomas Munro <tmunro@postgresql.org>
date : Sat, 22 Nov 2025 20:51:16 +1300
committer: Thomas Munro <tmunro@postgresql.org>
date : Sat, 22 Nov 2025 20:51:16 +1300
Click here for diff
LLVM 21 changed the arguments of RTDyldObjectLinkingLayer's
constructor, breaking compilation with the backported
SectionMemoryManager from commit 9044fc1d.
https://github.com/llvm/llvm-project/commit/cd585864c0bbbd74ed2a2b1ccc191eed4d1c8f90
Backpatch-through: 14
Author: Holger Hoffstätte <holger@applied-asynchrony.com>
Reviewed-by: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Discussion: https://postgr.es/m/d25e6e4a-d1b4-84d3-2f8a-6c45b975f53d%40applied-asynchrony.com
M src/backend/jit/llvm/llvmjit_wrap.cpp
Stamp 13.23.
commit : 89df812eb890814b105d871185935b580478e660
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:59:18 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:59:18 -0500
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 9a219bb0038a7c56eb4ea9680e1d0c7043a81c88
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
Click here for diff
Stamp 14.20.
commit : 9ad034be354da9af1cea76836a9e576c110d1ff3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:58:00 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:58:00 -0500
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : ee953cd8f0a9325ad67fef94539df8b4201efafe
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
Click here for diff
Stamp 15.15.
commit : 32f38816779420502d4a311835d5fe939e9548a0
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:56:47 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:56:47 -0500
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 70d03b5f4f9e585a5a1425e89af234015e2c63c5
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
Click here for diff
Stamp 16.11.
commit : d61dd817be70749d14e982a369e97fdda9d5cba6
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:55:22 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:55:22 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : b2e70cc348992012cab140172d0aaf9a3bec6b0b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
Click here for diff
Stamp 17.7.
commit : fbb530a3dff569222bea7098ad4de3d8bde97740
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:53:58 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 16:53:58 -0500
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : 2c0382f98b3fa05f482b94c706169f6bebbc92ea
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Nov 2025 13:36:13 -0500
Click here for diff
v2.57.0: Suppress Repository Symlinks
commit : d9773a31c97077761ee8e7d06e073b0b0734e26f
author : David Steele <david@pgbackrest.org>
date : Sat, 18 Oct 2025 11:07:36 +0200
committer: David Steele <david@pgbackrest.org>
date : Sat, 18 Oct 2025 11:07:36 +0200
Click here for diff
Bug Fixes:
* Unnest HTTP/TLS/socket timeouts. (Reviewed by David Christensen.)
* Fix possible segfault in page checksum error message. (Fixed by Zsolt Parragi. Reviewed by David Steele.)
Features:
* Add repo-symlink option to suppress creation of repository symlinks. (Reviewed by Douglas J Hunley. Suggested by Ron Johnson.)
Improvements:
* Add HTTP retries for 408 and 429 errors. (Reviewed by David Christensen.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release/2025/2.57.0.xml
M meson.build
M src/version.h
Stamp 13.22.
commit : af2dbe860b638dbd45604270d103e0a59dc0a372
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:10:58 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:10:58 -0400
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 17d41fc70d5b87a1fc1b41d045a9634da120a74f
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
Click here for diff
Stamp 14.19.
commit : 4e9da016ade3e75400f6fdc22ed1fed7fdd32f7a
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:09:37 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:09:37 -0400
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 2e19ad79e1a14e5dacd0ad3a3ec959fff928ca17
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
Click here for diff
Stamp 15.14.
commit : 0ab43b548237b3791261480d6a023f6b95b53942
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:08:18 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:08:18 -0400
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 4eb9733b2b76aeaca84e450be8c7653012ab215a
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
Click here for diff
Stamp 16.10.
commit : c13dd7d50f21268dc64b4b3edbce31993985ab12
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:06:43 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:06:43 -0400
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : 18d01671ef2576f7f950c2797a467370bc1a654d
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
Click here for diff
Stamp 17.6.
commit : 7885b94dd81b98bbab9ed878680d156df7bf857f
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:04:51 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 17:04:51 -0400
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : 86ad5a84c76b0ed1cf9ddb1d88f7204a9a076051
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 11 Aug 2025 15:37:32 -0400
Click here for diff
v2.56.0: Progress Info Improvements
commit : eca9290a2a6583fd0dd9156ee6ef6cf26899336e
author : David Steele <david@pgbackrest.org>
date : Mon, 21 Jul 2025 10:12:22 -0400
committer: David Steele <david@pgbackrest.org>
date : Mon, 21 Jul 2025 10:12:22 -0400
Click here for diff
Bug Fixes:
* Fix issue with adhoc expiration when no backups in a repository. (Reviewed by Stefan Fercot. Reported by Anup Gupta.)
Features:
* Add restore progress to info command output. (Contributed by Denis Garsh, Maxim Michkov. Reviewed by David Steele.)
* Add progress-only detail level for info command output. (Contributed by Denis Garsh. Reviewed by David Steele, Stefan Fercot.)
Improvements:
* Retry failed reads on object stores. (Reviewed by David Christensen.)
* Fix defaults in command-line help. (Reviewed by David Christensen, Chris Bandy.)
Documentation Improvements:
* Describe discrete option values in a list where appropriate. (Contributed by Anton Kurochkin. Reviewed by David Steele.)
* Fix "less than" in help output for archive-mode option. (Contributed by Anton Kurochkin. Reviewed by David Steele.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release/2025/2.56.0.xml
M meson.build
M src/version.h
Stamp 13.21.
commit : 8b3c5d9f5299666e2c548cc6e18d837d52f2ab2e
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:34:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:34:49 -0400
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 5dff5ce8636660772f23493918e69af91c820321
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
Click here for diff
Stamp 14.18.
commit : 8bde80e30edd408a5bef4d5612db0bb173206293
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:33:27 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:33:27 -0400
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : d9cee6a5f2ad73e1c13b619fdc2d42961079dbc3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
Click here for diff
Stamp 15.13.
commit : 5261b40acb67fdb8ed1e5976ae99599f16864c93
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:31:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:31:49 -0400
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : 4b6f246b6791904b16d277138800a3f8a4ece847
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
Click here for diff
Stamp 16.9.
commit : 6e4ab1b69197e2756192a1019439aebacdea5497
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:30:08 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:30:08 -0400
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : ce12d66ce731a863abb489dfb9b3f01a4537ee73
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
Click here for diff
Stamp 17.5.
commit : 5e2f3df49d4298c6097789364a5a53be172f6e85
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:28:35 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 16:28:35 -0400
Click here for diff
M configure
M configure.ac
M meson.build
Last-minute updates for release notes.
commit : ecbe349e9128b678311a2b8e328cbe258d7807ed
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 5 May 2025 11:29:49 -0400
Click here for diff
v2.55.1: Bug Fixes
commit : 665f261ea4e8a89d116a22e9fb5ad12676665622
author : David Steele <david@pgbackrest.org>
date : Mon, 5 May 2025 13:10:22 -0400
committer: David Steele <david@pgbackrest.org>
date : Mon, 5 May 2025 13:10:22 -0400
Click here for diff
Bug Fixes:
* Revert "calculate content-md5 on S3 only when required". (Reviewed by David Christensen. Reported by Frank Brendel.)
* Fix lower bounds checking for option keys. (Reviewed by David Christensen, Wolfgang Walther. Reported by Wolfgang Walther.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release/2025/2.55.1.xml
M meson.build
M src/version.h
M test/code-count/file-type.yaml
v2.55.0: Verification Improvements and PostgreSQL 18 Support
commit : 6c90196e74ef0da38568f08fd7cb234d10130e79
author : David Steele <david@pgbackrest.org>
date : Mon, 21 Apr 2025 18:25:00 -0400
committer: David Steele <david@pgbackrest.org>
date : Mon, 21 Apr 2025 18:25:00 -0400
Click here for diff
Bug Fixes:
* Fix block incremental restore issue on non-default repository. (Reviewed by David Christensen, Aleksander Łukasz. Reported by Aleksander Łukasz.)
* Do not set recovery_target_timeline=current for PostgreSQL < 12. (Reviewed by Stefan Fercot.)
* Fix expire archive range logging. (Reviewed by Stefan Fercot. Reported by Aleš Zelený.)
* Fix error reporting for queries with no results. (Reviewed by Stefan Fercot. Reported by Susantha Bathige.)
Features:
* Verify recovery target timeline. (Reviewed by Stefan Fercot.)
* Allow verification of a specified backup. (Contributed by Maxim Michkov. Reviewed by David Steele.)
* Add support for S3/GCS requester pays. (Contributed by Timothée Peignier. Reviewed by David Steele.)
* PostgreSQL 18 experimental support. (Reviewed by Stefan Fercot.)
* Allow connections to PostgreSQL on abstract domain sockets. (Reviewed by Chris Bandy. Suggested by Chris Bandy.)
* Add numeric output to version command. (Contributed by Stefan Fercot. Reviewed by David Steele.)
Improvements:
* Allow backup command to operate on remote repositories. (Reviewed by Stefan Fercot.)
* Use lz4 for protocol compression. (Reviewed by Stefan Fercot.)
* Calculate content-md5 on S3 only when required. (Reviewed by David Christensen.)
* Warn when a value for a multi-key option is overwritten. (Reviewed by David Christensen, Stefan Fercot.)
* Add detail logging for expired archive path. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Remove support for PostgreSQL 9.4. (Reviewed by Stefan Fercot.)
* Remove autoconf/make build. (Reviewed by David Christensen.)
Documentation Improvements:
* Fix documentation for specifying multiple stanzas with tls-server-auth. (Reviewed by David Christensen, Stefan Fercot. Suggested by Terry MacAndrew.)
* Clarify incremental backup expiration. (Reviewed by Stefan Fercot.)
* Clarify requirement for local/remote pgBackRest versions to match. (Contributed by Greg Clough. Reviewed by David Steele.)
* Add FAQ about exporting self-contained cluster. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Caveat --tablespace-map-all regarding tablespace creation. (Reviewed by Stefan Fercot, Christophe Courtois. Suggested by Christophe Courtois.)
* Clarify behavior of --repo-retention-full-type. (Reviewed by Antoine Beaupré. Suggested by Antoine Beaupré.)
* Change --process-max recommendation for object stores to --repo-bundle. (Reviewed by Stefan Fercot.)
* Update unix_socket_directory to unix_socket_directories. (Contributed by hyunkyu han. Reviewed by David Steele.)
* Recommend not placing spool-path within pg_xlog/pg_wal. (Reviewed by Martín Marqués, Don Seiler. Suggested by Martín Marqués.)
M CONTRIBUTING.md
M README.md
M doc/RELEASE.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release/2025/2.55.0.xml
M meson.build
M src/version.h
M test/code-count/file-type.yaml
Stamp 1.5.3.
commit : b5e3d92c56e2cbfa95329e35ebd43da8f1ff667e
author : David Steele <david@pgbackrest.org>
date : Wed, 19 Feb 2025 13:58:09 -0600
committer: David Steele <david@pgbackrest.org>
date : Wed, 19 Feb 2025 13:58:09 -0600
Click here for diff
M Makefile
A pgaudit–1.5.2–1.5.3.sql
R100 pgaudit–1.5.2.sql pgaudit–1.5.3.sql
M pgaudit.control
Add exception for call statement to stack check.
commit : a4547309100ebd75e48d6a7958c07bc2cf2268de
author : Alper Kocatas <alperkocatas@gmail.com>
date : Tue, 18 Feb 2025 20:42:47 +0300
committer: David Steele <david@pgbackrest.org>
date : Tue, 18 Feb 2025 20:42:47 +0300
Click here for diff
Stamp 1.6.3.
commit : abdb653a57228c28c52600aefa4852616eb6b0af
author : David Steele <david@pgbackrest.org>
date : Wed, 19 Feb 2025 13:53:15 -0600
committer: David Steele <david@pgbackrest.org>
date : Wed, 19 Feb 2025 13:53:15 -0600
Click here for diff
M Makefile
A pgaudit–1.6.2–1.6.3.sql
R100 pgaudit–1.6.2.sql pgaudit–1.6.3.sql
M pgaudit.control
Add exception for call statement to stack check.
commit : ff66faa6fc3dbbf236357171eda05e9a322276c7
author : Alper Kocatas <alperkocatas@gmail.com>
date : Tue, 18 Feb 2025 20:42:47 +0300
committer: David Steele <david@pgbackrest.org>
date : Tue, 18 Feb 2025 20:42:47 +0300
Click here for diff