Life with Open Source

PostgreSQL 9.6.24 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : 4d31470705451b7f571ca2f59f133ed482943d3e author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 10:20:09 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 10:20:09 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

PostgreSQL 10.19 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : 13e52d7c553327c41620a678720477079c8a5802 author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 10:12:59 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 10:12:59 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

PostgreSQL 11.14 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : d61cdad0b52465934703500fe3c22aa6f0bb0018 author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:59:33 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:59:33 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

PostgreSQL 12.9 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : 4048fc458175dbcd7cd81e8ef75ca1ba0ab9bdae author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:50:06 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:50:06 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

PostgreSQL 13.0 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : 23469b867ac000b8ed36fdeaab5c40ba9be23772 author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:36:27 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:36:27 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

PostgreSQL 14.0 (upcoming) commit log

Back-patch "Add parent table name in an error in reorderbuffer.c." commit : 9e84f6a7213314f6f6dcb66651525d1b7eda8591 author : Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:24:59 +0530 committer: Amit Kapila <akapila@postgresql.org> date : Thu, 21 Oct 2021 09:24:59 +0530 Click here for diff This was originally done in commit 5e77625b26 for 15 only, as a troubleshooting aid but multiple people showed interest in back-patching this. Author: Jeremy Schneider Reviewed-by: Amit Kapila Backpatch-through: 9.

pgBackRest 2.37 (upcoming) commit log

Convert page checksum filter result to a pack. commit : c8ea17c68f8fa72f2bf3b979539be3f709448493 author : David Steele <david@pgmasters.net> date : Fri, 24 Sep 2021 17:40:31 -0400 committer: David Steele <david@pgmasters.net> date : Fri, 24 Sep 2021 17:40:31 -0400 Click here for diff The pack is both more compact and more efficient than a variant. Also aggregate the page error info in the main process rather than in the filter to allow additional LSN filtering, to be added in a future commit.

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