Life with Open Source

PostgreSQL 19.0 (upcoming) commit log

Fix incorrect function name in comments

commit   : 23792d7381583d04c4bbd0a8507566401ec013d3    
  
author   : Alexander Korotkov <akorotkov@postgresql.org>    
date     : Sat, 15 Nov 2025 12:16:54 +0200    
  
committer: Alexander Korotkov <akorotkov@postgresql.org>    
date     : Sat, 15 Nov 2025 12:16:54 +0200    

Click here for diff

Update comments to reference WaitForLSN() instead of the outdated  
WaitForLSNReplay() function name.  
  
Discussion: https://postgr.es/m/CABPTF7UieOYbOgH3EnQCasaqcT1T4N6V2wammwrWCohQTnD_Lw%40mail.gmail.com  
Author: Xuneng Zhou <xunengzhou@gmail.com>  
Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com>  

M src/backend/commands/wait.c
M src/include/access/xlogwait.h

PostgreSQL 18.0 (upcoming) commit log

Comment out autovacuum_worker_slots in postgresql.conf.sample.

commit   : c732139924718eed4c9b88d54051efbdf8152fb1    
  
author   : Nathan Bossart <nathan@postgresql.org>    
date     : Fri, 14 Nov 2025 13:45:04 -0600    
  
committer: Nathan Bossart <nathan@postgresql.org>    
date     : Fri, 14 Nov 2025 13:45:04 -0600    

Click here for diff

All settings in this file should be commented out.  In addition to  
fixing that, also fix the indentation for this line.  
  
Oversight in commit c758119e5b.  
  
Reported-by: Daniel Gustafsson <daniel@yesql.se>  
Author: Daniel Gustafsson <daniel@yesql.se>  
Discussion: https://postgr.es/m/19727040-3EE4-4719-AF4F-2548544113D7%40yesql.se  
Backpatch-through: 18  

M src/backend/utils/misc/postgresql.conf.sample

PostgreSQL 13.23 commit log

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

PostgreSQL 14.20 commit log

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

PostgreSQL 15.15 commit log

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

PostgreSQL 16.11 commit log

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

PostgreSQL 17.7 commit log

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

pgBackRest 2.63 commit log

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

PostgreSQL 13.22 commit log

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

PostgreSQL 14.19 commit log

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

PostgreSQL 15.14 commit log

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

PostgreSQL 16.10 commit log

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

PostgreSQL 17.6 commit log

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

pgBackRest 2.62 commit log

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

PostgreSQL 13.21 commit log

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

PostgreSQL 14.18 commit log

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

PostgreSQL 15.13 commit log

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

PostgreSQL 16.9 commit log

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

PostgreSQL 17.5 commit log

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

pgBackRest 2.61 commit log

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

pgBackRest 2.60 commit log

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

pgAudit 1.5.4 commit log

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

pgAudit 1.6.4 commit log

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