Life with Open Source

PostgreSQL 19.0 (upcoming) commit log

doc PG 19 relnotes: properly indent XML

commit   : 2f15cec90d5d1e43bad743dc376ca33edfa24d95    
  
author   : Bruce Momjian <bruce@momjian.us>    
date     : Sat, 14 Nov 2026 14:25:53 -0500    
  
committer: Bruce Momjian <bruce@momjian.us>    
date     : Sat, 14 Nov 2026 14:25:53 -0500    

Click here for diff

Backpatch-through: 19 only  

M doc/src/sgml/release-19.sgml

Exclude new pages from VACUUM reltuples estimates

commit   : e2b2267d24e79f58ba25f1cd2e168059d2f23c26    
  
author   : Melanie Plageman <melanieplageman@gmail.com>    
date     : Fri, 13 Nov 2026 16:50:59 -0500    
  
committer: Melanie Plageman <melanieplageman@gmail.com>    
date     : Fri, 13 Nov 2026 16:50:59 -0500    

Click here for diff

PostgreSQL 20.0 (upcoming) commit log

Remove unused tuple expansion and copying functions

commit   : 81b2179b492e3af891544813b7e22a42386b34d0    
  
author   : Andres Freund <andres@anarazel.de>    
date     : Sat, 14 Nov 2026 12:43:45 -0500    
  
committer: Andres Freund <andres@anarazel.de>    
date     : Sat, 14 Nov 2026 12:43:45 -0500    

Click here for diff

minimal_expand_tuple() has been unused since 4da597edf1b and  
heap_expand_tuple() since 20d3fe9009d, which in turn left the static  
expand_tuple() unreachable.  heap_copytuple_with_tuple() has had no  
callers since 141fd1b66ce.  Remove them.  
  
Two regression test comments naming expand_tuple() are updated to  
refer to the code that handles missing attributes nowadays.  
  
Reported-by: Andres Freund <andres@anarazel.de>  
Reported-by: Tom Lane <tgl@sss.pgh.pa.us>  
Author: Aleksander Alekseev <aleksander@tigerdata.com>  
Reviewed-by: Kyle Snavely <kjsnavely@gmail.com>  
Discussion: https://postgr.es/m/gf6hokynqjp6g7o4zh6yy7ekbdbig5cnnd6ilk6iw3aodilj43%405x7xrz52jhve  

M src/backend/access/common/heaptuple.c
M src/include/access/htup_details.h
M src/test/regress/expected/fast_default.out
M src/test/regress/sql/fast_default.sql

PostgreSQL 14.25 commit log

Stamp 14.25.

commit   : 9adcf5f8847e0f485a390b1d3ea40688068d71bd    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:16:32 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:16:32 -0500    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 1a6533506b3e6639fe6e48ee881b31aa76bfca54    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    

Click here for diff

PostgreSQL 15.20 commit log

Stamp 15.20.

commit   : 6a84c5137e820f46f0123276f546eec5b9a56e70    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:14:54 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:14:54 -0500    

Click here for diff

M configure
M configure.ac

Last-minute updates for release notes.

commit   : 588ac6507696303da5ca645460ebcd7b11659a82    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    

Click here for diff

PostgreSQL 16.16 commit log

Stamp 16.16.

commit   : c0534eb02de050ac1035ad7b3ad7c3f02980f153    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:12:54 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:12:54 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : b72e2acba126f06ba0a36436af0fafce2bd4e19d    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    

Click here for diff

PostgreSQL 17.12 commit log

Stamp 17.12.

commit   : 702b3dc86d35bcc08c8e23cffa3c4d9fe9d32c85    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:11:08 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:11:08 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : 18c4a9c5f66a1fdf02be21751b931338a04d5790    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    

Click here for diff

PostgreSQL 18.6 commit log

Stamp 18.7.

commit   : f5c41f6681c910b3f69951bf6fb97c6d74605d25    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:09:29 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 15:09:29 -0500    

Click here for diff

M configure
M configure.ac
M meson.build

Last-minute updates for release notes.

commit   : aed4c42bce80dda767277cf983baec4678c55daf    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 Nov 2026 12:43:05 -0500    

Click here for diff

pgBackRest 2.69 commit log

v2.60.0: Page Checksum Errors and Object Store Prefetch

commit   : 2e1c4f2ba727c45a0a23d4b326905088dc15b1a1    
  
author   : David Steele <david@pgbackrest.org>    
date     : Sun, 18 Oct 2026 10:31:33 +0200    
  
committer: David Steele <david@pgbackrest.org>    
date     : Sun, 18 Oct 2026 10:31:33 +0200    

Click here for diff

IMPORTANT NOTE: The restore command will now error and stop if any restored file contains an invalid page checksum, which leaves the cluster incomplete and unable to start, so the restore must be rerun. The expire command will now refuse to expire if the oldest retained backup would contain checksum errors, which also prevents archive from being expired in that repository. Set checksum-page-error=n to warn instead of erroring.  
  
Features:  
  
* Add checksum-page-error option to error on invalid page checksums. (Contributed by Andrew Pogrebnoi. Reviewed by Douglas J Hunley, David Steele, Greg Sabino Mullane, Stefan Fercot. Suggested by Greg Sabino Mullane.)  
* Support for GCS Workload Identity Federation. (Contributed by Adol Rodriguez. Reviewed by Douglas J Hunley, David Steele.)  
* Prefetch multi-file/range reads from object stores. (Reviewed by Andrew Pogrebnoi, Douglas J Hunley.)  
  
Improvements:  
  
* Reduce keep-alive requests to remote processes. (Reviewed by Douglas J Hunley.)  
* Retry Azure batch sub-requests missing from the response. (Reviewed by Douglas J Hunley.)  
* Reduce the manifest checks made when reconstructing backup.info. (Reviewed by Douglas J Hunley. Suggested by todeb.)  
* Use original size to determine if a file should be bundled. (Reviewed by Douglas J Hunley.)  
* Add context to block map read errors during backup. (Reviewed by Stefan Fercot, Douglas J Hunley.)  
* Cast current_timestamp to text in the backup start label. (Contributed by Tiago Corcelli de Oliveira. Reviewed by David Steele.)  
* Support building on illumos. (Contributed by Kalevi Kolttonen. Reviewed by Douglas J Hunley, David Steele.)  
* Support OpenSSL 4. (Reviewed by Douglas J Hunley.)  
* Fix clang builds. (Reviewed by Douglas J Hunley.)  
* Migrate code generation from C to Python.  
  
Documentation Improvements:  
  
* Modernize the website. Special thanks to Jan for the insightful (and hilarious) logo. (Contributed by David Steele, Jan Wieremjewicz. Reviewed by Steve Atkins, Kai Wagner, Douglas J Hunley, Nikolaos Stamatopoulos, Matt Hudson, Stefan Fercot.)  
* Document the release schedule.  
* Migrate the documentation tools from C and Perl to Python.  
  
Test Suite Improvements:  
  
* Migrate the test harness from C and Perl to Python.  
* Add a Fil-C job to CI.  
* Add fuzz testing for the JSON, Ini, and Pack readers.  
* Allow test user names that adduser on Debian rejects. (Contributed by Stefan Fercot. Reviewed by David Steele.)  

M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/index.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.0.xml
M doc/xml/release/2020s/2026/2.59.2.xml
M doc/xml/release/2020s/2026/2.60.0.xml
M meson.build
M src/version.h

pgBackRest 2.68 commit log

v2.59.3: Weak Encryption Subkey Bug

commit   : 46cdca625a73403cad4774d97354a1fac1e91e51    
  
author   : David Steele <david@pgbackrest.org>    
date     : Sun, 4 Oct 2026 09:29:49 +0200    
  
committer: David Steele <david@pgbackrest.org>    
date     : Sun, 4 Oct 2026 09:29:49 +0200    

Click here for diff

IMPORTANT NOTE: In prior versions it was possible for weak encryption subkeys and salts to be generated if there was an error accessing system random data.  
  
Bug Fixes:  
  
* Fix possible checksum error loading encrypted info and manifest files. (Fixed by j0uinim. Reviewed by David Steele.)  
* Fix possible weak encryption subkeys/salts. (Fixed by j0uinim. Reviewed by David Steele, Stefan Fercot, Douglas J Hunley.)  

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/index.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.3.xml
M meson.build
M src/version.h

pgBackRest 2.67 commit log

v2.59.2: PostgreSQL 19beta4 Support

commit   : d5138e2e3b92fe806505bc8b9c69f36bd70cea18    
  
author   : David Steele <david@pgbackrest.org>    
date     : Sun, 27 Sep 2026 14:15:45 +0300    
  
committer: David Steele <david@pgbackrest.org>    
date     : Sun, 27 Sep 2026 14:15:45 +0300    

Click here for diff

Bug Fixes:  
  
* Fix empty block map when file is truncated to zero during backup. (Reviewed by Douglas J Hunley. Reported by JPCOSTA78.)  
* Disable read retry when filters are passed to the driver. (Reviewed by Douglas J Hunley. Reported by megamaced.)  
* Fix pagination of S3 version listing. (Reviewed by Douglas J Hunley, guruguruguru. Reported by guruguruguru.)  
* Set the Azure version header for SAS authentication. (Reviewed by Douglas J Hunley. Reported by Florian Helmberger.)  
* Fix async archive-push stalling on a zero-size backup history file. (Fixed by Andrew Kroh. Reviewed by David Steele, Douglas J Hunley.)  
* Fix annotate command on a remote encrypted repository. (Fixed by Douglas J Hunley. Reviewed by David Steele.)  
  
Features:  
  
* PostgreSQL 19beta4 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/index.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.2.xml
M meson.build
M src/version.h