Life with Open Source

PostgreSQL 14.0 (upcoming) commit log

Fix EXPLAIN to handle SEARCH BREADTH FIRST queries. commit : 388726753b638fb9938883bdd057b2ffe6f950f5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 16 Sep 2021 10:45:42 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 16 Sep 2021 10:45:42 -0400 Click here for diff The rewriter transformation for SEARCH BREADTH FIRST produces a FieldSelect on a Var of type RECORD, where the Var references the recursive union's worktable output. EXPLAIN VERBOSE failed to handle this case, because it only expected such Vars to appear in CteScans not WorkTableScans.

PostgreSQL 9.6.24 (upcoming) commit log

Fix variable shadowing in procarray.c. commit : 9b2cc7856c40f3558b787fb1e170d551860f3b99 author : Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:08:31 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:08:31 +0900 Click here for diff ProcArrayGroupClearXid function has a parameter named "proc", but the same name was used for its local variables. This commit fixes this variable shadowing, to improve code readability. Back-patch to all supported versions, to make future back-patching easy though this patch is classified as refactoring only.

PostgreSQL 10.19 (upcoming) commit log

Fix variable shadowing in procarray.c. commit : 639d731acc2b6a998e262a29d5a4a6f5b3340952 author : Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 Click here for diff ProcArrayGroupClearXid function has a parameter named "proc", but the same name was used for its local variables. This commit fixes this variable shadowing, to improve code readability. Back-patch to all supported versions, to make future back-patching easy though this patch is classified as refactoring only.

PostgreSQL 11.14 (upcoming) commit log

Fix variable shadowing in procarray.c. commit : 8d28ec21f0c3b2defb94afd168efa0a1c60b1a2d author : Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 Click here for diff ProcArrayGroupClearXid function has a parameter named "proc", but the same name was used for its local variables. This commit fixes this variable shadowing, to improve code readability. Back-patch to all supported versions, to make future back-patching easy though this patch is classified as refactoring only.

PostgreSQL 12.9 (upcoming) commit log

Fix variable shadowing in procarray.c. commit : 24c57aa62937d2dc8b5e91c1ec95e0f8966fb0c4 author : Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 Click here for diff ProcArrayGroupClearXid function has a parameter named "proc", but the same name was used for its local variables. This commit fixes this variable shadowing, to improve code readability. Back-patch to all supported versions, to make future back-patching easy though this patch is classified as refactoring only.

PostgreSQL 13.0 (upcoming) commit log

Fix variable shadowing in procarray.c. commit : 8767a86fa2b1d24537cca318a26fc68d7e457911 author : Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Thu, 16 Sep 2021 13:07:29 +0900 Click here for diff ProcArrayGroupClearXid function has a parameter named "proc", but the same name was used for its local variables. This commit fixes this variable shadowing, to improve code readability. Back-patch to all supported versions, to make future back-patching easy though this patch is classified as refactoring only.

pgBackRest 2.37 (upcoming) commit log

Revert Azurite version for testing to 3.14.0. commit : c38d6926d6c9aa01b895a28e66fc0aa6965350a3 author : David Steele <david@pgmasters.net> date : Thu, 9 Sep 2021 08:48:45 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 9 Sep 2021 08:48:45 -0400 Click here for diff 3.14.2 is causing breakage in the documentation. There is no obvious cause so for now just revert to the last working version. M doc/xml/user-guide.xml M test/lib/pgBackRestTest/Env/Host/HostAzureTest.pm Migrate command-line help generation to C.

pgBackRest 2.36 commit log

v2.35: Binary Protocol commit : 3787cf78032cb928f27044c13b6f50d57bf06d20 author : David Steele <david@pgmasters.net> date : Mon, 23 Aug 2021 06:52:51 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 23 Aug 2021 06:52:51 -0400 Click here for diff IMPORTANT NOTE: The log level for copied files in the backup/restore commands has been changed to detail. This makes the info log level less noisy but if these messages are required then set the log level for the backup/restore commands to detail.

PostgreSQL 9.6.23 commit log

Stamp 9.6.23. commit : b979c788a9b79b615457e94b6e9f709513fe2e27 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:56:33 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:56:33 -0400 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 : eb8423e63b22421fb028cf0461c1298824d1cd98 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 9 Aug 2021 12:59:39 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 9 Aug 2021 12:59:39 +0200 Click here for diff

PostgreSQL 10.18 commit log

Stamp 10.18. commit : 29abec3a62229a37ce21203acdeb03a7860c1102 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:54:22 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:54:22 -0400 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 : f2295cfe878249cfb7b2da3f5bae48ca29958fdf author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 9 Aug 2021 12:58:41 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 9 Aug 2021 12:58:41 +0200 Click here for diff

PostgreSQL 11.13 commit log

Stamp 11.13. commit : 2b4006920ca0d0a579579aecff65ef7fe81185bb author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:52:43 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:52:43 -0400 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 : f334490131be5ef1935c56bece186f3afa5fbded author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 14:41:00 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.8 commit log

Stamp 12.8. commit : de835071fda945fb5e40340d3ea8dd2ca13e725c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:50:41 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 16:50:41 -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 : c6afcafafe95df08f98eea7ac5d5b3ab30f22db4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Aug 2021 14:41:00 -0400 committer: Tom Lane <tgl@sss.

pgAudit 1.1.4 (upcoming) commit log

Add automated testing using Github Actions. commit : c6ae67a37e5dd26f4ecf65b2698c75858ed21f56 author : David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 09:04:51 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 09:04:51 -0400 Click here for diff Both Debian and RHEL Dockerfiles are provided so also remove the Vagrantfile. A .github/workflows/test.yml M .gitignore M README.md A test/Dockerfile.debian A test/Dockerfile.rhel A test/README.md D test/Vagrantfile A test/test.sh Add .editorconfig. commit : c4c8c9a6f72958b3332fa0e2cae901247587da2a author : David Steele <david@pgmasters.

pgAudit 1.2.3 (upcoming) commit log

Add automated testing using Github Actions. commit : 4248288a35010f625261d2cabf8e8cad1fcfd072 author : David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:54:02 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:54:02 -0400 Click here for diff Both Debian and RHEL Dockerfiles are provided so also remove the Vagrantfile. A .github/workflows/test.yml M .gitignore M README.md A test/Dockerfile.debian A test/Dockerfile.rhel A test/README.md D test/Vagrantfile A test/test.sh Add .editorconfig. commit : 0568967d3a36f0d166c7c35ece1d9ca7abd0e6af author : David Steele <david@pgmasters.

pgAudit 1.3.3 (upcoming) commit log

Add automated testing using Github Actions. commit : ec9d9c4a16191630169adc33220c27a7df4cab3c author : David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:46:17 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:46:17 -0400 Click here for diff Both Debian and RHEL Dockerfiles are provided so also remove the Vagrantfile. A .github/workflows/test.yml M .gitignore M README.md A test/Dockerfile.debian A test/Dockerfile.rhel A test/README.md D test/Vagrantfile A test/test.sh Add .editorconfig. commit : d6c3a821f6d539aed8a63ac2b28e3b2dec8cd163 author : David Steele <david@pgmasters.

pgAudit 1.4.2 (upcoming) commit log

Remove remaining references to Vagrant. commit : 6afeae52d8e4569235bf6088e983d95ec26f13b7 author : David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:22:32 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:22:32 -0400 Click here for diff Testing is entirely Docker-based now. M .gitignore M README.md Fix logic to properly classify SELECT FOR UPDATE as SELECT. commit : bd6a261f72e08daa3a5f36b46aa4b1728d23709b author : David Steele <dwsteele@users.noreply.github.com> date : Thu, 5 Aug 2021 08:02:22 -0400 committer: GitHub <noreply@github.

pgAudit 1.5.1 (upcoming) commit log

Remove remaining references to Vagrant. commit : 6afeae52d8e4569235bf6088e983d95ec26f13b7 author : David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:22:32 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 5 Aug 2021 08:22:32 -0400 Click here for diff Testing is entirely Docker-based now. M .gitignore M README.md Fix logic to properly classify SELECT FOR UPDATE as SELECT. commit : bd6a261f72e08daa3a5f36b46aa4b1728d23709b author : David Steele <dwsteele@users.noreply.github.com> date : Thu, 5 Aug 2021 08:02:22 -0400 committer: GitHub <noreply@github.

pgBackRest 2.35 commit log

v2.34: PostgreSQL 14 Support commit : d10a99d73b772f221807024abbf61fdc5ca3a800 author : David Steele <david@pgmasters.net> date : Mon, 7 Jun 2021 06:51:08 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 7 Jun 2021 06:51:08 -0400 Click here for diff Bug Fixes: * Fix issues with leftover spool files from a prior restore. (Reviewed by Cynthia Shang, Stefan Fercot, Floris van Nee. Reported by Floris van Nee.) * Fix issue when checking links for large numbers of tablespaces.

PostgreSQL 9.6.22 commit log

Stamp 9.6.22. commit : 836dda6f1b31c5f7c70ebf52537364ffc3eff577 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:50:15 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:50:15 -0400 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 : cc6c63f8a26d9706bc4b256ac075401bb3d5f759 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:30 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.17 commit log

Stamp 10.17. commit : cffc8fd1ecb09fcd4d8aa98134f4ba8613a01a3a author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:47:56 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:47:56 -0400 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 : 25387cc56d344eaa9545b8233496296cf6087477 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.12 commit log

Stamp 11.12. commit : fae98e3293de89f2fe8fc6e7c196d351378ce80e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:45:49 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:45:49 -0400 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 : 6c1cfccf226645f4c01b4fee8df2c4e3392f2a32 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.7 commit log

Stamp 12.7. commit : 4bf0bce161097869be5a56706b31388ba15e0113 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:43:52 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:43:52 -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 : a9c718bd2d35586da8ebdefa0b72fe7e0d1a725b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

pgBackRest 2.34 commit log

v2.33: Multi-Repository and GCS Support commit : a3d89143d6b34c6019cd29e059d28487037fd109 author : David Steele <david@pgmasters.net> date : Mon, 5 Apr 2021 09:18:20 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Apr 2021 09:18:20 -0400 Click here for diff Bug Fixes: * Fix option warnings breaking async archive-get/archive-push. (Reviewed by Cynthia Shang. Reported by Lev Kokotov.) * Fix memory leak in backup during archive copy. (Reviewed by Cynthia Shang. Reported by Christian ROUX, Efremov Egor.

PostgreSQL 9.5.25 commit log

Stamp 9.5.25. commit : 202c587e2f28bc295f6935d044e20680b627e7a1 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:03:12 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:03:12 -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 : c20a8efa6e2a7374f4cddb76e76213f63b7d7ac5 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:13:24 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:13:24 +0100 Click here for diff