doc: Fix section of functions age(xid) and mxid_age(xid)
commit : 15afb7d61c142a9254a6612c6774aff4f358fb69
author : Michael Paquier <[email protected]>
date : Wed, 20 Nov 2024 14:20:52 +0900
committer: Michael Paquier <[email protected]>
date : Wed, 20 Nov 2024 14:20:52 +0900
Click here for diff
In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based on
the discussion that led to 48b5aa3143, this is not intentional as this
could break many existing monitoring queries. Note that vacuumdb also
uses both of them.
In 16, both functions were listed under "Control Data Functions", which
is incorrect, so let's move them to the list of functions related to
transaction IDs and snapshots.
Author: Bertrand Drouvot
Discussion: https://postgr.es/m/[email protected]
Discussion: https://postgr.es/m/[email protected]
Backpatch-through: 16
M doc/src/sgml/func.sgml
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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