v2.38: Minor Bug Fixes and Improvements
commit : 5249b89a2e94fdbb45461faaf2e1b0304b986ac7
author : David Steele <david@pgmasters.net>
date : Sun, 6 Mar 2022 10:30:59 -0600
committer: David Steele <david@pgmasters.net>
date : Sun, 6 Mar 2022 10:30:59 -0600
Click here for diff
IMPORTANT NOTE: Repository size reported by the info command is now entirely based on what pgBackRest has written to storage. Previously, in certain cases, pgBackRest could detect if additional compression was being applied by the storage but this is no longer supported.
Bug Fixes:
* Retry errors in S3 batch file delete. (Reviewed by Reid Thompson. Reported by Alex Richman.)
* Allow case-insensitive matching of HTTP connection header values. (Reviewed by Reid Thompson. Reported by Rémi Vidier.)
Features:
* Add support for AWS S3 server-side encryption using KMS. (Contributed by Christoph Berg. Reviewed by David Steele, Tharindu Amila.)
* Add archive-missing-retry option. (Reviewed by Stefan Fercot.)
* Add backup type filter to info command. (Contributed by Stefan Fercot. Reviewed by David Steele.)
Improvements:
* Retry on page validation failure during backup. (Reviewed by Stephen Frost, David Christensen.)
* Handle TLS servers that do not close connections gracefully. (Reviewed by Rémi Vidier, David Christensen, Stephen Frost.)
* Add backup LSNs to info command output. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Automatically strip trailing slashes for repo-ls paths. (Contributed by David Christensen. Reviewed by David Steele.)
* Do not retry fatal errors. (Reviewed by Reid Thompson.)
* Remove support for PostgreSQL 8.3/8.4. (Reviewed by Reid Thompson, Stefan Fercot.)
* Remove logic that tried to determine additional file system compression. (Reviewed by Reid Thompson, Stefan Fercot.)
Documentation Bug Fixes:
* Move repo options in TLS documentation to the global section. (Reported by Anton Kurochkin.)
* Remove unused backup-standby option from stanza commands. (Reported by Stefan Fercot.)
* Fix typos in help and release notes. (Fixed by Daniel Gustafsson. Reviewed by David Steele.)
Documentation Improvements:
* Add aliveness check to systemd service configuration. (Suggested by Yogesh Sharma.)
* Add FAQ explaining WAL archive suffix. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Note that replications slots are not restored. (Contributed by Reid Thompson. Reviewed by David Steele, Stefan Fercot. Suggested by Christophe Courtois.)
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.xml
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
Stamp 1.2.4.
commit : 6d9e5d4ae4b0baf5039845fb71f6e7d52669bbd8
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:30:21 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:30:21 -0600
Click here for diff
M Makefile
A pgaudit–1.2.3–1.2.4.sql
R100 pgaudit–1.2.3.sql pgaudit–1.2.4.sql
M pgaudit.control
Skip logging script statements for create/alter extension.
commit : 74c4c07899fba3cc7bc791be6b03810786b06762
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 14:16:17 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 14:16:17 -0600
Click here for diff
Stamp 1.3.4.
commit : 6f7799839465a39dc1887e4ad10ef2f67519cd1e
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:25:39 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:25:39 -0600
Click here for diff
M Makefile
A pgaudit–1.3.3–1.3.4.sql
R100 pgaudit–1.3.3.sql pgaudit–1.3.4.sql
M pgaudit.control
Skip logging script statements for create/alter extension.
commit : 0a41dfcdb5fcd52d9da1ee0c1c2d174e15934fe8
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 13:47:40 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 13:47:40 -0600
Click here for diff
Stamp 1.4.3.
commit : 21fea0792139529302e02af145c90f7ec5cff2eb
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:19:52 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:19:52 -0600
Click here for diff
M Makefile
A pgaudit–1.4.2–1.4.3.sql
R100 pgaudit–1.4.2.sql pgaudit–1.4.3.sql
M pgaudit.control
Skip logging script statements for create/alter extension.
commit : 28ab91b8cee30da902d33b3b61a8b62934814370
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 12:37:07 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 12:37:07 -0600
Click here for diff
Stamp 1.5.2.
commit : 59d9574ab966f69a549e3f8f60c1829ee5b78b3b
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:14:43 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:14:43 -0600
Click here for diff
M Makefile
A pgaudit–1.5.1–1.5.2.sql
R100 pgaudit–1.5.1.sql pgaudit–1.5.2.sql
M pgaudit.control
Skip logging script statements for create/alter extension.
commit : 30996af6fc5dd4a832e8d57b05179482867d109b
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 12:10:53 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 12:10:53 -0600
Click here for diff
Stamp 1.6.2.
commit : 267eb83a14ca29f37821f297974991206aa91dee
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:00:56 -0600
committer: David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 15:00:56 -0600
Click here for diff
M Makefile
A pgaudit–1.6.1–1.6.2.sql
R100 pgaudit–1.6.1.sql pgaudit–1.6.2.sql
M pgaudit.control
Skip logging script statements for create/alter extension.
commit : 6460d9fec78c344245c70309551bb314415268a8
author : David Steele <david@pgmasters.net>
date : Fri, 25 Feb 2022 11:27:12 -0600
committer: GitHub <noreply@github.com>
date : Fri, 25 Feb 2022 11:27:12 -0600
Click here for diff
Stamp 10.20.
commit : fa362d2b3bde0f99ba8a22486205de11b2e00e14
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:21:57 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:21:57 -0500
Click here for diff
M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Translation updates
commit : 217257fac07426cf4c0c2def14f1cb19c330d36a
author : Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:53:57 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:53:57 +0100
Click here for diff
Stamp 11.15.
commit : ff2a6d2621439d3d3f6e340c363d3b5e71749919
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:20:23 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:20:23 -0500
Click here for diff
M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Translation updates
commit : d793dcf28b5dc6da4a76cbf3c059b36c2c8763f4
author : Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:51:36 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:51:36 +0100
Click here for diff
Stamp 12.10.
commit : ec24521950fb055488e3ab2c652ffbf7fe0180b9
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:19:04 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:19:04 -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
Translation updates
commit : 3b00428f1f453dd1beba64385c57efd4cb67d57f
author : Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:44:07 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:44:07 +0100
Click here for diff
Stamp 13.6.
commit : d7db9572070a627bae9919fd1b4e16c8208d4fca
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:17:41 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:17:41 -0500
Click here for diff
M configure
M configure.in
Translation updates
commit : 7f7148b72e2b63274d93da6ea43f1493f4e92aa8
author : Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:36:22 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:36:22 +0100
Click here for diff
Stamp 14.2.
commit : 78b1ddc753b3e5e3f3e9eb0e7519b48146018394
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:15:36 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 7 Feb 2022 16:15:36 -0500
Click here for diff
M configure
M configure.ac
Translation updates
commit : 3c879e61d9ad5968e88e12620e270808b6cb76f5
author : Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:31:57 +0100
committer: Peter Eisentraut <peter@eisentraut.org>
date : Mon, 7 Feb 2022 13:31:57 +0100
Click here for diff
v2.37: TLS Server
commit : f18f2d9991da29533ad8e9859074c4f39185420f
author : David Steele <david@pgmasters.net>
date : Mon, 3 Jan 2022 08:43:55 -0500
committer: David Steele <david@pgmasters.net>
date : Mon, 3 Jan 2022 08:43:55 -0500
Click here for diff
Bug Fixes:
* Fix restore delta link mapping when path/file already exists. (Reviewed by Reid Thompson. Reported by Younes Alhroub.)
* Fix socket leak on connection retries. (Reviewed by Reid Thompson. Reported by James Coleman.)
Features:
* Add TLS server. (Reviewed by Stephen Frost, Reid Thompson, Andrew L'Ecuyer.)
* Add --cmd option. (Contributed by Reid Thompson. Reviewed by Stefan Fercot, David Steele. Suggested by Virgile CREVON.)
Improvements:
* Check archive immediately after backup start. (Reviewed by Reid Thompson, David Christensen.)
* Add timeline and checkpoint checks to backup. (Reviewed by Stefan Fercot, Reid Thompson.)
* Check that clusters are alive and correctly configured during a backup. (Reviewed by Stefan Fercot.)
* Error when restore is unable to find a backup to match the time target. (Reviewed by Reid Thompson, Douglas J Hunley. Suggested by Douglas J Hunley.)
* Parse protocol/port in S3/Azure endpoints. (Contributed by Reid Thompson. Reviewed by David Steele.)
* Add warning when checkpoint_timeout exceeds db-timeout. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Add verb to HTTP error output. (Contributed by Christoph Berg. Reviewed by David Steele.)
* Allow y/n arguments for boolean command-line options. (Contributed by Reid Thompson. Reviewed by David Steele.)
* Make backup size logging exactly match info command output. (Contributed by Reid Thompson. Reviewed by David Steele. Suggested by Mahomed Hussein.)
Documentation Improvements:
* Display size option default and allowed values with appropriate units. (Reviewed by Reid Thompson.)
* Fix typos and improve documentation for the tablespace-map-all option. (Reviewed by Reid Thompson. Suggested by Reid Thompson.)
* Remove obsolete statement about future multi-repository support. (Suggested by David Christensen.)
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.xml
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
Stamp 9.6.24.
commit : a4116b8d5a4f68803452d8f1aa3f74f302049a90
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:07:24 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:07:24 -0500
Click here for diff
M configure
M configure.in
M doc/bug.template
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 : cace98d76cab8882125f6fbbe919f789fe2b9ee3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
Stamp 10.19.
commit : 477008d10fb5a024038ed23f0beba901f1f47ae2
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:05:38 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:05:38 -0500
Click here for diff
M configure
M configure.in
M doc/bug.template
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 : 3eadebaa975d8a0af444b8ecc4a84854cdd7920a
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
Stamp 11.14.
commit : 7f05af399052dab32c28c253fa891dc1e8b4224b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:04:02 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:04:02 -0500
Click here for diff
M configure
M configure.in
M doc/bug.template
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 : 965e7b1e8531341fed3ade7d03d9ee85fa7793d4
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
Stamp 12.9.
commit : 8a94efd9bb71c2d5473836ce4899aedb9b4cfb2e
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:02:19 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:02:19 -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 : 9f06c0755e8f9dc8d196b3dc8722138bf04d5d59
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
Stamp 13.5.
commit : 084346ccee8ead6b387a90cdf6a29036ae9ec77e
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:00:24 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 17:00:24 -0500
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 402c3ba3954d81531b6c9ff9b5d554552a85c6a7
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
Stamp 14.1.
commit : 0a455b8d61d8fc5a7d1fdc152667f9ba1fd27fda
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 16:58:24 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 16:58:24 -0500
Click here for diff
M configure
M configure.ac
Last-minute updates for release notes.
commit : ddc6917c314ddcf16f56dd2cfd52fbc721760b07
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 8 Nov 2021 14:02:16 -0500
Click here for diff
commit : 99e8cfac264909c7dd6fb45a1e3c71a8dacc0b26
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:18:42 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:18:42 -0400
Click here for diff
M pgaudit–1.0–1.0.6.sql
M pgaudit–1.0.6–1.0.7.sql
M pgaudit–1.0.7–1.0.8.sql
commit : c565fd9cdfcb4395ee3ec5de9b9dbb4c04c594b0
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:17:41 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:17:41 -0400
Click here for diff
M pgaudit–1.0–1.1.1.sql
M pgaudit–1.1.1–1.1.2.sql
M pgaudit–1.1.2–1.1.3.sql
Add security definer and search_path to event trigger functions.
commit : 818f11262bc1dff677d83a3053cba2b3f4e32bab
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:23:05 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:23:05 -0400
Click here for diff
commit : c565fd9cdfcb4395ee3ec5de9b9dbb4c04c594b0
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:17:41 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:17:41 -0400
Click here for diff
M pgaudit–1.0–1.1.1.sql
M pgaudit–1.1.1–1.1.2.sql
M pgaudit–1.1.2–1.1.3.sql
commit : 8ddd48fc9688b7f059fcb2c41a319f8dfd3aa64c
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:16:59 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:16:59 -0400
Click here for diff
M pgaudit–1.2–1.2.1.sql
M pgaudit–1.2.1–1.2.2.sql
Add security definer and search_path to event trigger functions.
commit : 065845b52948a831ab620232a27bc2ac1ab63bd9
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:15:54 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:15:54 -0400
Click here for diff
commit : 6eb8b141711c04185abcd8d7d148effd3fb083e7
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:16:27 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 18:16:27 -0400
Click here for diff
M pgaudit–1.3–1.3.1.sql
M pgaudit–1.3.1–1.3.2.sql
Add security definer and search_path to event trigger functions.
commit : 96f5da19ff66892ca35da91a1e44fe9028aa5c25
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:09:04 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:09:04 -0400
Click here for diff
Add security definer and search_path to event trigger functions.
commit : d364aa95386113df4d68f80fbe7905c75924dc82
author : David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:29:06 -0400
committer: David Steele <david@pgmasters.net>
date : Thu, 4 Nov 2021 17:29:06 -0400
Click here for diff
Similar to #156, this prevents users from defining their own versions of functions used in the event triggers. Either one should be sufficient on its own, but both provides better defense against regressions.
M Makefile
A pgaudit–1.0.8–1.0.9.sql
R083 pgaudit–1.0.8.sql pgaudit–1.0.9.sql
M pgaudit.control