v2.60.1: Annotate and SFTP Fixes
commit : 7aeba299c49abd768ca741506569007a5cab0870
author : David Steele <david@pgbackrest.org>
date : Mon, 16 Nov 2026 08:49:15 -0300
committer: David Steele <david@pgbackrest.org>
date : Mon, 16 Nov 2026 08:49:15 -0300
Click here for diff
Bug Fixes:
* Fix annotate saving backup.info to the default repository. (Reviewed by Stefan Fercot, Douglas J Hunley.)
* Fix possible block incremental restore failure on SFTP storage. (Reviewed by Douglas J Hunley. Reported by Fineline19.)
* Fix use of SFTP file handles after a reconnect. (Reviewed by Douglas J Hunley.)
* Fix excessive memory use by the memory context free list. (Fixed by Vasiliy Koshkin. Reviewed by David Steele, Douglas J Hunley.)
* Do not lower a minimum TLS version set by the OpenSSL config. (Reviewed by Douglas J Hunley, Stefan Fercot.)
* Fix reporting of OpenSSL errors. (Reviewed by Douglas J Hunley, Stefan Fercot.)
Documentation Improvements:
* Document TLS settings skipped when repo-storage-verify-tls=n.
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/news.xml
M doc/xml/release/2020s/2026/2.59.2.xml
M doc/xml/release/2020s/2026/2.60.1.xml
M meson.build
M src/version.h
doc: Clarify restrictions on --filenode in pg_checksums
commit : 7fc2f0423320e02beb8c44b863f1827604c47c75
author : Daniel Gustafsson <dgustafsson@postgresql.org>
date : Mon, 16 Nov 2026 12:17:48 +0100
committer: Daniel Gustafsson <dgustafsson@postgresql.org>
date : Mon, 16 Nov 2026 12:17:48 +0100
Click here for diff
The --filenode option can only be used together with --check, but this
was omitted from the documentation.
Author: Sri Vishnu <sri207881@gmail.com>
Discussion: https://postgr.es/m/CANM6wF+aVU3DmWnX1Mnb3tWJhcXdOnPE+92kag9vLf1q-6xFEQ@mail.gmail.com
M doc/src/sgml/ref/pg_checksums.sgml
Translation updates
commit : 7f40ddf3cf6e89eecb225e374928ce3991d45012
author : Álvaro Herrera <alvherre@kurilemu.de>
date : Mon, 16 Nov 2026 10:40:01 +0100
committer: Álvaro Herrera <alvherre@kurilemu.de>
date : Mon, 16 Nov 2026 10:40:01 +0100
Click here for diff
Source-Git-URL: ssh://git@git.postgresql.org/pgtranslation/messages.git
Source-Git-Hash: c2a723a234730a4729f410c92608888219ca2ab5
M src/backend/po/de.po
M src/backend/po/es.po
M src/backend/po/ja.po
M src/backend/po/zh_CN.po
M src/backend/po/zh_TW.po
M src/bin/initdb/po/es.po
M src/bin/pg_amcheck/po/es.po
M src/bin/pg_archivecleanup/po/es.po
M src/bin/pg_archivecleanup/po/fr.po
M src/bin/pg_basebackup/po/es.po
M src/bin/pg_basebackup/po/fr.po
M src/bin/pg_checksums/po/es.po
M src/bin/pg_combinebackup/po/es.po
M src/bin/pg_combinebackup/po/fr.po
M src/bin/pg_combinebackup/po/ja.po
M src/bin/pg_config/po/es.po
M src/bin/pg_controldata/po/es.po
M src/bin/pg_controldata/po/fr.po
M src/bin/pg_ctl/po/es.po
M src/bin/pg_dump/po/de.po
M src/bin/pg_dump/po/es.po
M src/bin/pg_dump/po/fr.po
M src/bin/pg_dump/po/ja.po
M src/bin/pg_dump/po/zh_CN.po
M src/bin/pg_dump/po/zh_TW.po
M src/bin/pg_resetwal/po/es.po
M src/bin/pg_resetwal/po/fr.po
M src/bin/pg_rewind/po/es.po
M src/bin/pg_rewind/po/fr.po
M src/bin/pg_test_fsync/po/es.po
M src/bin/pg_test_timing/po/es.po
M src/bin/pg_test_timing/po/fr.po
M src/bin/pg_upgrade/po/es.po
M src/bin/pg_upgrade/po/fr.po
M src/bin/pg_upgrade/po/ja.po
M src/bin/pg_verifybackup/po/es.po
M src/bin/pg_verifybackup/po/fr.po
M src/bin/pg_waldump/po/es.po
M src/bin/pg_waldump/po/fr.po
M src/bin/pg_walsummary/po/es.po
M src/bin/psql/po/es.po
M src/bin/psql/po/fr.po
M src/bin/psql/po/ja.po
M src/bin/psql/po/ka.po
M src/bin/scripts/po/es.po
M src/bin/scripts/po/fr.po
M src/interfaces/ecpg/ecpglib/po/es.po
M src/interfaces/ecpg/ecpglib/po/fr.po
M src/interfaces/ecpg/preproc/po/es.po
M src/interfaces/libpq/po/es.po
M src/interfaces/libpq/po/fr.po
M src/pl/plperl/po/es.po
M src/pl/plperl/po/fr.po
M src/pl/plperl/po/zh_CN.po
M src/pl/plperl/po/zh_TW.po
M src/pl/plpgsql/src/po/de.po
M src/pl/plpgsql/src/po/es.po
M src/pl/plpgsql/src/po/fr.po
M src/pl/plpgsql/src/po/ja.po
M src/pl/plpgsql/src/po/zh_CN.po
M src/pl/plpgsql/src/po/zh_TW.po
M src/pl/plpython/po/es.po
M src/pl/plpython/po/fr.po
M src/pl/tcl/po/es.po
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
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
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
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
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
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
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