Life with Open Source

PostgreSQL 18.0 (upcoming) commit log

Refactor some SQL/JSON error messages

commit   : 62b7a9a7784eb8b3871368726fc3b8df17d87f32    
  
author   : Álvaro Herrera <[email protected]>    
date     : Sat, 14 Dec 2024 12:55:00 +0100    
  
committer: Álvaro Herrera <[email protected]>    
date     : Sat, 14 Dec 2024 12:55:00 +0100    

Click here for diff

Turn type names into "%s" specifiers to 1) avoid getting them translated  
and 2) reduce the total number of messages.  

M src/backend/utils/adt/jsonpath_exec.c

PostgreSQL 12.22 commit log

Stamp 12.22.

commit   : 498f30a8b7025a2a7bd3715acc1d1692122ba542    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:41:03 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:41:03 -0500    

Click here for diff

M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Release notes for 17.2, 16.6, 15.10, 14.15, 13.18, 12.22.

commit   : c4b39f26dc881d6496561f87c43a04c6dc1ba12f    
  
author   : Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:10:08 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:10:08 -0500    

Click here for diff

PostgreSQL 13.18 commit log

Stamp 13.18.

commit   : 4f8df7a3fb750007ff5018f8125e0d4793cab337    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:39:24 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:39:24 -0500    

Click here for diff

M configure
M configure.in

Fix recently-exposed portability issue in regex optimization.

commit   : adb6dbc7f5353afbd0f7ac07e6cc41a54ea2818a    
  
author   : Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    

Click here for diff

PostgreSQL 14.15 commit log

Stamp 14.15.

commit   : 4f5b14879d8271a73786105bf8aafda347dd7aea    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:37:40 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:37:40 -0500    

Click here for diff

M configure
M configure.ac

Fix recently-exposed portability issue in regex optimization.

commit   : df1a2633b11a3d3738eb614f17a0ea5bae719950    
  
author   : Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    

Click here for diff

PostgreSQL 15.10 commit log

Stamp 15.10.

commit   : a4bd20b6d7f9d42750b797c450592f55d5374c1f    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:35:15 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:35:15 -0500    

Click here for diff

M configure
M configure.ac

Fix recently-exposed portability issue in regex optimization.

commit   : 6ab39c02747c33173e5e33291e66cebbdbc75d82    
  
author   : Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sun, 17 Nov 2024 14:14:06 -0500    

Click here for diff

PostgreSQL 16.6 commit log

Stamp 16.6.

commit   : 1f47e7b59b92c58eee6840325d1aaa6acee84194    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:33:54 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:33:54 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Release notes for 17.2, 16.6, 15.10, 14.15, 13.18, 12.22.

commit   : 7a0ecaa497d85b0445d2f06abf670ec329b59a5c    
  
author   : Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:09:53 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:09:53 -0500    

Click here for diff

PostgreSQL 17.2 commit log

Stamp 17.2.

commit   : 6304632eaa2107bb1763d29e213ff166ff6104c0    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:32:12 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 18 Nov 2024 15:32:12 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Release notes for 17.2, 16.6, 15.10, 14.15, 13.18, 12.22.

commit   : 9ac1003320fd34f7f3f89443213b714d42cc9c8e    
  
author   : Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:09:53 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Sat, 16 Nov 2024 17:09:53 -0500    

Click here for diff

PostgreSQL 12.21 commit log

Stamp 12.21.

commit   : 20a82026828536331ebe912b86f060078a173633    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:50:23 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:50:23 -0500    

Click here for diff

M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Last-minute updates for release notes.

commit   : aee114bf1c84368db9e50ba4e7340ce632f89e19    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

PostgreSQL 13.17 commit log

Stamp 13.17.

commit   : 64ecc00908b7557afa911c15bb342ff06845bb19    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:48:40 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:48:40 -0500    

Click here for diff

M configure
M configure.in

Last-minute updates for release notes.

commit   : b3db5fdb05b6ca499f75d0ecf290dbd057bfb075    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

PostgreSQL 14.14 commit log

Stamp 14.14.

commit   : 8abd1324049759c1cbd81a4793c470a4f43e1fdb    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:47:15 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:47:15 -0500    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 575d673fe78f76e396ea7eb8160c30d96ccfea0f    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

PostgreSQL 15.9 commit log

Stamp 15.9.

commit   : 0c53d54c812cea0d840490fd107910ed949e18c2    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:45:41 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:45:41 -0500    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : b83b358b1bac61ca46af995a3da83cc515a434c6    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

PostgreSQL 16.5 commit log

Stamp 16.5.

commit   : 8c9d34cdc4d213a57fa8b8a7197f7d6f22fca4c9    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:44:10 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:44:10 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : 03dc78ff644ca0c090cb4cdbf8fba64230e54238    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

PostgreSQL 17.1 commit log

Stamp 17.1.

commit   : 91f20bc2f7e4fcf5de5c65a6cb1190e0afa91c0b    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:42:37 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:42:37 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : 052aa02971f2dd476c14689033727a0b8563d5d2    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 11 Nov 2024 17:40:13 -0500    

Click here for diff

pgBackRest 2.57 commit log

v2.54.0: Target Time for Versioned Storage

commit   : 1e5f46b7d9626eadfcf99d08cb984a74085ee0c8    
  
author   : David Steele <[email protected]>    
date     : Mon, 21 Oct 2024 08:57:43 +0300    
  
committer: David Steele <[email protected]>    
date     : Mon, 21 Oct 2024 08:57:43 +0300    

Click here for diff

NOTE TO PACKAGERS: This is last feature release to support the autoconf/make build. Please migrate to meson if you have not already done so. 2.54.X patch releases (if any) will continue to support autoconf/make.  
  
Bug Fixes:  
  
* Fix PostgreSQL query performance for large datasets. (Fixed by Thibault Vincent, David Steele. Reviewed by David Christensen, Antoine Millet. Reported by Antoine Millet.)  
  
Features:  
  
* Allow repositories on versioned storage to be read at a target time. (Reviewed by Stefan Fercot, David Christensen.)  
* Allow requested standby backup to proceed with no standby. (Reviewed by Stefan Fercot.)  
  
Improvements:  
  
* Summarize backup reference list for info command text output. (Contributed by Stefan Fercot. Reviewed by David Steele.)  
* Refresh web-id token for each S3 authentication. (Contributed by Brent Graveland. Reviewed by David Steele.)  
* Correctly display current values for indexed options in help. (Reviewed by David Christensen.)  
* Save backup.info only when contents have changed. (Reviewed by Stefan Fercot.)  
* Remove limitation on reading files in parallel during restore. (Reviewed by David Christensen.)  
* Improve SFTP error messages. (Contributed by Reid Thompson. Reviewed by David Steele.)  
  
Documentation Features:  
  
* Add performance tuning section to user guide. (Reviewed by Stefan Fercot.)  
  
Documentation Improvements:  
  
* Clarify source for data_directory. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Matthias.)  
* Better logic for deciding when a summary should be lower-cased. (Suggested by Daniel Westermann.)  

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.xml
R088 doc/xml/release/2024/2.54.xml doc/xml/release/2024/2.54.0.xml
M meson.build
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml

PostgreSQL 17.0 commit log

Stamp 17.0.

commit   : d7ec59a63d745ba74fba0e280bbf85dc6d1caa3e    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 23 Sep 2024 16:02:53 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 23 Sep 2024 16:02:53 -0400    

Click here for diff

M configure
M configure.ac
M meson.build

Translation updates

commit   : 29d483fb33229f4322ca6cd040422ac508c678c1    
  
author   : Peter Eisentraut <[email protected]>    
date     : Mon, 23 Sep 2024 12:06:47 +0200    
  
committer: Peter Eisentraut <[email protected]>    
date     : Mon, 23 Sep 2024 12:06:47 +0200    

Click here for diff

pgBackRest 2.56 commit log

v2.53.1: PostgreSQL 17beta3 Support

commit   : b84a3dd08c7eeea81ce4c77d0bb0c7ad16f61f4c    
  
author   : David Steele <[email protected]>    
date     : Mon, 19 Aug 2024 11:16:14 +0700    
  
committer: David Steele <[email protected]>    
date     : Mon, 19 Aug 2024 11:16:14 +0700    

Click here for diff

Bug Fixes:  
  
* Fix permissions when restore run as root user. (Reviewed by Stefan Fercot. Reported by Will M.)  
* Fix segfault on delayed connection errors. (Reviewed by David Christensen. Reported by Anton Glushakov.)  
* Skip local repository duplicate check for SFTP. (Fixed by Reid Thompson. Reviewed by David Steele. Reported by Anton Kurochkin.)  
  
Improvements:  
  
* PostgreSQL 17beta3 support.  

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/2024/2.53.1.xml
M meson.build
M src/build/configure.ac
M src/configure
M src/version.h

PostgreSQL 12.20 commit log

Stamp 12.20.

commit   : 76265a851b13bbb001a218481c0cb6315c0fdfe6    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:11:34 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:11:34 -0400    

Click here for diff

M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Last-minute updates for release notes.

commit   : 1b85e65846aa16ede7aeddd67a9bd16ec73a18ae    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    

Click here for diff

PostgreSQL 13.16 commit log

Stamp 13.16.

commit   : 0dc08bbfcc93ac4f04d2a3f4b9d1231a80e2cc0c    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:09:59 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:09:59 -0400    

Click here for diff

M configure
M configure.in

Last-minute updates for release notes.

commit   : 429560193282f2c29a1bb9f28a055c87b7605253    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    

Click here for diff

PostgreSQL 14.13 commit log

Stamp 14.13.

commit   : 33965476b6ef6a37af2bc9bb1b5b2af17c35dc5e    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:08:36 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:08:36 -0400    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : b942cc42b7c659da70c205151bde5e1f9af2ece0    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    

Click here for diff

PostgreSQL 15.8 commit log

Stamp 15.8.

commit   : 3cc5e51ab4507b33acc82684b7d79ac43b8a6b5d    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:07:10 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:07:10 -0400    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 6eca8a5673307ce52f892f083df0b958d35f09e1    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    

Click here for diff

PostgreSQL 16.4 commit log

Stamp 16.4.

commit   : 2caa85f4aae689e6f6721d7363b4c66a2a6417d6    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:05:35 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 16:05:35 -0400    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : c04778592d6db6197819f95028347af135709e4b    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 5 Aug 2024 14:03:20 -0400    

Click here for diff

pgBackRest 2.55 commit log

v2.53: Concurrent Backups

commit   : 6e8a45f650e303fe74a1e34ee8e76a193dbc6c4a    
  
author   : David Steele <[email protected]>    
date     : Mon, 22 Jul 2024 09:33:31 +0700    
  
committer: David Steele <[email protected]>    
date     : Mon, 22 Jul 2024 09:33:31 +0700    

Click here for diff

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.  
  
NOTE TO PACKAGERS: The lz4 library is now required by the meson build.  
  
NOTE TO PACKAGERS: Compiler support for __builtin_clzl() and __builtin_bswap64() is now required by the meson build.  
  
Bug Fixes:  
  
* Fix SFTP renaming failure when file already exists. (Fixed by Reid Thompson. Reviewed by David Steele. Reported by ahmed112212.)  
  
Features:  
  
* Allow backups to run concurrently on different repositories. (Reviewed by Reid Thompson, Stefan Fercot.)  
* Support IP-based SANs for TLS certificate validation. (Contributed by David Christensen. Reviewed by David Steele.)  
  
Improvements:  
  
* Default log-level-stderr option to off. (Reviewed by Greg Sabino Mullane, Stefan Fercot.)  
* Allow alternative WAL segment sizes for PostgreSQL ≤ 10. (Contributed by Viktor Kurilko. Reviewed by David Steele.)  
* Add hint to check SFTP authorization log. (Contributed by Vitalii Zurian. Reviewed by Reid Thompson, David Steele.)  
  
Documentation Improvements:  
  
* Clarify archive-push multi-repo behavior. (Reviewed by Stefan Fercot.)  

M CONTRIBUTING.md
M README.md
M doc/lib/pgBackRestDoc/Custom/DocCustomRelease.pm
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release.xml
A doc/xml/release/2024/2.52.1.xml
M doc/xml/release/2024/2.53.xml
M meson.build
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml

pgBackRest 2.54 commit log

v2.52.1: Bug Fix

commit   : cc9035c2456e00eef463724dfc6900f68dd9c3fc    
  
author   : David Steele <[email protected]>    
date     : Tue, 25 Jun 2024 11:46:44 +0800    
  
committer: David Steele <[email protected]>    
date     : Tue, 25 Jun 2024 11:46:44 +0800    

Click here for diff

Bug Fixes:  
  
* Fix issue with files larger on the replica than on the primary. (Reviewed by Stefan Fercot. Reported by Nicolas Lassimonne.)  

M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/release/2024/2.52.1.xml
M meson.build
M src/build/configure.ac
M src/configure
M src/version.h

pgBackRest 2.53 commit log

v2.52: PostgreSQL 17 support

commit   : dfc14b193454b3003c10eb2d021699cbd6294004    
  
author   : David Steele <[email protected]>    
date     : Mon, 27 May 2024 11:13:16 +1000    
  
committer: David Steele <[email protected]>    
date     : Mon, 27 May 2024 11:13:16 +1000    

Click here for diff

NOTE TO PACKAGERS: The build system for pgBackRest is now meson. The autoconf/make build will not receive any new features and will be removed after a few releases.  
  
Features:  
  
* Add GCS batch delete support. (Reviewed by Reid Thompson.)  
* S3 SSE-C encryption support. (Reviewed by Tim Jones. Suggested by Tim Jones.)  
* PostgreSQL 17 support. (Reviewed by Stefan Fercot.)  
  
Improvements:  
  
* Allow explicit disabling of optional dependencies in meson builds. (Contributed by Michael Schout. Reviewed by David Steele.)  
* Dynamically find python in meson build. (Contributed by Michael Schout. Reviewed by David Steele.)  
* Tag pgbackrest build target in meson as installable. (Contributed by Bradford Boyle. Reviewed by David Steele.)  
  
Documentation Improvements:  
  
* Update start/stop documentation to reflect actual functionality. (Reviewed by Stefan Fercot.)  

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/2024/2.52.xml
M meson.build
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml

PostgreSQL 12.19 commit log

Stamp 12.19.

commit   : 01aeb431c12a3388594a445ca97e71cbed410ed2    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 May 2024 16:27:39 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 May 2024 16:27:39 -0400    

Click here for diff

M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Translation updates

commit   : 51da12633a3d7b4b9f715c41deac4d7d4c94248b    
  
author   : Peter Eisentraut <[email protected]>    
date     : Mon, 6 May 2024 12:15:05 +0200    
  
committer: Peter Eisentraut <[email protected]>    
date     : Mon, 6 May 2024 12:15:05 +0200    

Click here for diff