Life with Open Source

PostgreSQL 11.9 (upcoming) commit log

Fix yet another issue with step generation in partition pruning. commit : 1db9c80f835e436ca3c27bccf43135ebf7e3c62b author : Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:04 +0900 committer: Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:04 +0900 Click here for diff Commit 13838740f fixed some issues with step generation in partition pruning, but there was yet another one: get_steps_using_prefix() assumes that clauses in the passed-in prefix list are sorted in ascending order of their partition key numbers, but the caller failed to ensure this for range partitioning, which led to an assertion failure in debug builds.

PostgreSQL 12.4 (upcoming) commit log

Fix yet another issue with step generation in partition pruning. commit : 4f26932296057721d7668ec13cfd6af2bb8410ec author : Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:02 +0900 committer: Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:02 +0900 Click here for diff Commit 13838740f fixed some issues with step generation in partition pruning, but there was yet another one: get_steps_using_prefix() assumes that clauses in the passed-in prefix list are sorted in ascending order of their partition key numbers, but the caller failed to ensure this for range partitioning, which led to an assertion failure in debug builds.

PostgreSQL 13.0 (upcoming) commit log

Fix yet another issue with step generation in partition pruning. commit : 199cec9779504c08aaa8159c6308283156547409 author : Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:00 +0900 committer: Etsuro Fujita <efujita@postgresql.org> date : Fri, 7 Aug 2020 14:45:00 +0900 Click here for diff Commit 13838740f fixed some issues with step generation in partition pruning, but there was yet another one: get_steps_using_prefix() assumes that clauses in the passed-in prefix list are sorted in ascending order of their partition key numbers, but the caller failed to ensure this for range partitioning, which led to an assertion failure in debug builds.

pgBackRest 2.30 (upcoming) commit log

Rename handle to fd. commit : cde2c756ea8ae32663e0a817098fc9f5d4f2a1f2 author : David Steele <david@pgmasters.net> date : Wed, 5 Aug 2020 18:25:07 -0400 committer: David Steele <david@pgmasters.net> date : Wed, 5 Aug 2020 18:25:07 -0400 Click here for diff Pretty much everywhere handle is used what is really meant is file descriptor (fd). This terminology got migrated over from Perl and is just not quite correct, or at least not as correct as fd.

PostgreSQL 10.14 (upcoming) commit log

doc: clarify "state" table reference in tutorial commit : 1ed7b43319efa27181a9ccda66f80b7e76ba8fa3 author : Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:10 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:10 -0400 Click here for diff Reported-by: Vyacheslav Shablistyy Discussion: https://postgr.es/m/159586122762.680.1361378513036616007@wrigleys.postgresql.org Backpatch-through: 9.5 M doc/src/sgml/advanced.sgml Increase hard-wired timeout values in ecpg regression tests. commit : 9bf2aeea8ea432b1a702313eae2186b4f946da21 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 4 Aug 2020 15:20:31 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.23 (upcoming) commit log

doc: clarify "state" table reference in tutorial commit : 74e1c967b533a334e61a2b343e2b6444067f6173 author : Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:09 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:09 -0400 Click here for diff Reported-by: Vyacheslav Shablistyy Discussion: https://postgr.es/m/159586122762.680.1361378513036616007@wrigleys.postgresql.org Backpatch-through: 9.5 M doc/src/sgml/advanced.sgml Doc: fix obsolete info about allowed range of TZ offsets in timetz. commit : d809d99cd4dba1e42d4f330289664453889900a5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 3 Aug 2020 13:11:16 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.19 (upcoming) commit log

doc: clarify "state" table reference in tutorial commit : d06c96185c427e34be8cfe7513e2195842423ea2 author : Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:09 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Wed, 5 Aug 2020 17:12:09 -0400 Click here for diff Reported-by: Vyacheslav Shablistyy Discussion: https://postgr.es/m/159586122762.680.1361378513036616007@wrigleys.postgresql.org Backpatch-through: 9.5 M doc/src/sgml/advanced.sgml Increase hard-wired timeout values in ecpg regression tests. commit : 1fac10d9fd8d836079ef66eec24cdcbf5979e68e author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 4 Aug 2020 15:20:31 -0400 committer: Tom Lane <tgl@sss.

pgAudit 1.2.2 (upcoming) commit log

Fix misclassification of partitioned tables. commit : 62cd995e0207e4c7dc5f26fb0629be61bddb726e author : gaoxueyu <44825804+gaoxueyu@users.noreply.github.com> date : Tue, 21 Jul 2020 13:43:19 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 21 Jul 2020 13:43:19 -0400 Click here for diff Partitioned tables were being classified as UNKNOWN but they should be classified as TABLE. M expected/pgaudit.out M pgaudit.c M sql/pgaudit.sql Update copyright end year. commit : 93bd45d1822516db627e3c0c88c8f3eba0f59187 author : David Steele <david@pgmasters.net> date : Thu, 18 Jun 2020 08:22:17 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.3.2 (upcoming) commit log

Fix misclassification of partitioned tables/indexes. commit : 966b751551b9f5b435793b83f3a5d442360964ad author : gaoxueyu <44825804+gaoxueyu@users.noreply.github.com> date : Tue, 21 Jul 2020 13:21:51 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 21 Jul 2020 13:21:51 -0400 Click here for diff Partitioned tables and indexes were being classified as UNKNOWN but they should be classified as TABLE/INDEX. M expected/pgaudit.out M pgaudit.c M sql/pgaudit.sql Update copyright end year. commit : 9a686ef2d4ddc47e2d0df09d3a20b22e8586cd9e author : David Steele <david@pgmasters.

pgBackRest 2.29 commit log

v2.28: Azure Repository Storage commit : 5a4b91f90a81019e456a50c0f7311824f7e61475 author : David Steele <david@pgmasters.net> date : Mon, 20 Jul 2020 08:57:22 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 20 Jul 2020 08:57:22 -0400 Click here for diff Bug Fixes: * Fix restore --force acting like --force --delta. This caused restore to replace files based on timestamp and size rather than overwriting, which meant some files that should have been updated were left unchanged.

pgAudit 1.1.3 (upcoming) commit log

Update copyright end year. commit : 7657139e6aabc70f2661e7e0cacaa85f6994957e author : David Steele <david@pgmasters.net> date : Thu, 18 Jun 2020 08:23:15 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 18 Jun 2020 08:23:15 -0400 Click here for diff M pgaudit.c Add *.bc to .gitignore. commit : e529e48ef43f73c17ea431976718f61986b53864 author : David Steele <david@pgmasters.net> date : Thu, 18 Jun 2020 08:09:58 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 18 Jun 2020 08:09:58 -0400 Click here for diff

pgBackRest 2.28 commit log

v2.27: Expiration Improvements and Compression Drivers commit : d8214e0d78ca8922eecb4da03008034c6a258b3b author : David Steele <david@pgmasters.net> date : Tue, 26 May 2020 08:11:50 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 26 May 2020 08:11:50 -0400 Click here for diff Bug Fixes: * Fix issue checking if file links are contained in path links. (Reviewed by Cynthia Shang. Reported by Christophe CavalliƩ.) * Allow pg-path1 to be optional for synchronous archive-push. (Reviewed by Cynthia Shang.

PostgreSQL 9.5.22 commit log

Stamp 9.5.22. commit : 7aa52945de3206191f8b2b121568d316ac4b234e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:16:09 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:16:09 -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 : 7ab65cd968b25519d864e0573dff9bca4431908b author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:31:50 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:31:50 +0200 Click here for diff

PostgreSQL 9.6.18 commit log

Stamp 9.6.18. commit : b3960286a6fa1b195a06cfc38701866e21394861 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:14:21 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:14:21 -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 : 3cbf235e56df461b18c371cbca6a9dc422b0d2f0 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:28:48 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:28:48 +0200 Click here for diff

PostgreSQL 10.13 commit log

Stamp 10.13. commit : a411361705cdf0c0d63d1de231d7ea33a030b4f9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:12:38 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:12:38 -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 : ce0bbdda3e3c2101efbb0a8915e9d057606059dc author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:26:52 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:26:52 +0200 Click here for diff

PostgreSQL 11.8 commit log

Stamp 11.8. commit : d439e27d5f57df1365b53688daa367d56d55599d author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:10:48 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:10:48 -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 : fcd89bbb70e2963c5f832191d3fd1f2a1d6443b6 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:24:12 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:24:12 +0200 Click here for diff

PostgreSQL 12.3 commit log

Stamp 12.3. commit : 5060275aa8a1ead56e0a41308d7a43049a6cbe43 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:08:58 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 May 2020 17:08:58 -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 : f2367aa0a4c7a5876c5b7a62306a156075c13190 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:19:18 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 11 May 2020 13:19:18 +0200 Click here for diff

pgBackRest 2.27 commit log

v2.26: Non-blocking TLS commit : 2352ecf7c0db8d12cda4759709b4cd570e1b5de4 author : David Steele <david@pgmasters.net> date : Mon, 20 Apr 2020 15:44:31 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 20 Apr 2020 15:44:31 -0400 Click here for diff Bug Fixes: * Remove empty subexpression from manifest regular expression. MacOS was not happy about this though other platforms seemed to work fine. (Fixed by David Raftis.) Improvements: * Non-blocking TLS implementation. (Reviewed by Slava Moudry, Cynthia Shang, Stephen Frost.

pgBackRest 2.26 commit log

v2.25: LZ4 Compression Support commit : fd3dca036b1436564dec17b7c23b62b9d9fa1051 author : David Steele <david@pgmasters.net> date : Thu, 26 Mar 2020 17:14:53 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 26 Mar 2020 17:14:53 -0400 Click here for diff Features: * Add lz4 compression support. Note that setting compress-type=lz4 will make new backups and archive incompatible (unrestorable) with prior versions of pgBackRest. (Reviewed by Cynthia Shang.) * Add --dry-run option to the expire command.

pgBackRest 2.25 commit log

v2.24: Auto-Select Backup Set for Time Target commit : 495dec44f0f512478ac942091ca2a29c60ad4911 author : David Steele <david@pgmasters.net> date : Tue, 25 Feb 2020 17:05:45 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 25 Feb 2020 17:05:45 -0500 Click here for diff Bug Fixes: * Prevent defunct processes in asynchronous archive commands. (Reviewed by Stephen Frost. Reported by Adam Brusselback, ejberdecia.) * Error when archive-get/archive-push/restore are not run on a PostgreSQL host. (Reviewed by Stephen Frost.

PostgreSQL 9.4.26 commit log

Stamp 9.4.26. commit : 30ffdd24d7222bc01183a56d536c236240674516 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:25:31 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:25:31 -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 : f6117744d14017cb11a6ddd95d4f44b114d871c7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.21 commit log

Stamp 9.5.21. commit : d9b89f1939cc33f14bb8c3f01ced946eb0febaa5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:23:16 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:23:16 -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 : 4153ac0d703593987f2fcac082d7fc04546c28cc author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.17 commit log

Stamp 9.6.17. commit : d48d8ba2361c93378d49050ff9526c8a7f289e34 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:21:38 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:21: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 : 3ede4280bce9ce567834cb79e9dfe66344526b18 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 10.12 commit log

Stamp 10.12. commit : 95d2576d023ec2a8b984472191b4e4be4205516e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:19:45 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:19:45 -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 : 27cfad5c8630428f7a2f63fd53b2e4a4fb248a90 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.