Life with Open Source

PostgreSQL 12.10 (upcoming) commit log

Fix pg_hba_file_rules for authentication method cert commit : aa58f5c53142782bd6a376a578d85d5ddd13d751 author : Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 committer: Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 Click here for diff For authentication method cert, clientcert=verify-full is implied. But the pg_hba_file_rules entry would incorrectly show clientcert=verify-ca. Per bug #17354 Reported-By: Feike Steenbergen Reviewed-By: Jonathan Katz Backpatch-through: 12 M src/backend/libpq/hba.c Revert "graceful shutdown" changes for Windows, in back branches only.

PostgreSQL 13.0 (upcoming) commit log

Fix pg_hba_file_rules for authentication method cert commit : 81596645ca2ba382918fca9e82aa3089db737e14 author : Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 committer: Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 Click here for diff For authentication method cert, clientcert=verify-full is implied. But the pg_hba_file_rules entry would incorrectly show clientcert=verify-ca. Per bug #17354 Reported-By: Feike Steenbergen Reviewed-By: Jonathan Katz Backpatch-through: 12 M src/backend/libpq/hba.c Revert "graceful shutdown" changes for Windows, in back branches only.

PostgreSQL 14.0 (upcoming) commit log

Fix pg_hba_file_rules for authentication method cert commit : 4afae689ead4ffbfdbaac1cd72794c729446596e author : Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 committer: Magnus Hagander <magnus@hagander.net> date : Wed, 26 Jan 2022 09:52:41 +0100 Click here for diff For authentication method cert, clientcert=verify-full is implied. But the pg_hba_file_rules entry would incorrectly show clientcert=verify-ca. Per bug #17354 Reported-By: Feike Steenbergen Reviewed-By: Jonathan Katz Backpatch-through: 12 M src/backend/libpq/hba.c Revert "graceful shutdown" changes for Windows, in back branches only.

PostgreSQL 10.20 (upcoming) commit log

Revert "graceful shutdown" changes for Windows, in back branches only. commit : 645c9457f296bdd674b3efc37047194db8233e66 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 25 Jan 2022 12:17:40 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 25 Jan 2022 12:17:40 -0500 Click here for diff This reverts commits 6051857fc and ed52c3707, but only in the back branches. Further testing has shown that while those changes do fix some things, they also break others; in particular, it looks like walreceivers fail to detect walsender-initiated connection close reliably if the walsender shuts down this way.

PostgreSQL 11.15 (upcoming) commit log

Revert "graceful shutdown" changes for Windows, in back branches only. commit : bbb1caf6b22027cc85212e8b4fbf8f1d61734329 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 25 Jan 2022 12:17:40 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 25 Jan 2022 12:17:40 -0500 Click here for diff This reverts commits 6051857fc and ed52c3707, but only in the back branches. Further testing has shown that while those changes do fix some things, they also break others; in particular, it looks like walreceivers fail to detect walsender-initiated connection close reliably if the walsender shuts down this way.

PostgreSQL 9.6.25 (upcoming) commit log

Suppress variable-set-but-not-used warning from clang 13. commit : f3653d7992358708baf401fcabb239b46d27942f author : Tom Lane <tgl@sss.pgh.pa.us> date : Sun, 23 Jan 2022 11:09:00 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Sun, 23 Jan 2022 11:09:00 -0500 Click here for diff In the normal configuration where GEQO_DEBUG isn't defined, recent clang versions have started to complain that geqo_main.c accumulates the edge_failures count but never does anything with it. As a minimal back-patchable fix, insert a void cast to silence this warning.

pgBackRest 2.38 commit log

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.

PostgreSQL 9.6.24 commit log

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.

PostgreSQL 10.19 commit log

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.

PostgreSQL 11.14 commit log

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.

PostgreSQL 12.9 commit log

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.

pgAudit 1.1.4 commit log

Remove unneeded version comments. 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.

pgAudit 1.1.6 (upcoming) commit log

Remove unneeded version comments. 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

pgAudit 1.2.3 commit log

Remove unneeded version comments. 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.

pgAudit 1.2.5 (upcoming) commit log

Remove unneeded version comments. 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

pgAudit 1.3.3 commit log

Remove unneeded version comments. 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.

pgAudit 1.3.5 (upcoming) commit log

Remove unneeded version comments. 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

pgAudit 1.4.2 commit log

Add security definer and search_path to event trigger functions. commit : a85f82cb902942a68528b02da0946c8642536806 author : David Steele <david@pgmasters.net> date : Thu, 4 Nov 2021 17:02:13 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 4 Nov 2021 17:02:13 -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.

pgAudit 1.5.1 commit log

Add security definer and search_path to event trigger functions. commit : 438fc93907bbd1c7c96d5acdd8a5a6307266cdfc author : David Steele <david@pgmasters.net> date : Thu, 4 Nov 2021 16:56:42 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 4 Nov 2021 16:56:42 -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.

pgAudit 1.4.4 (upcoming) commit log

Add security definer and search_path to event trigger functions. commit : 881c617084cac4985b9471426510af05c2a49dd7 author : David Steele <dwsteele@users.noreply.github.com> date : Thu, 4 Nov 2021 14:51:17 -0400 committer: GitHub <noreply@github.com> date : Thu, 4 Nov 2021 14:51:17 -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.