Life with Open Source

pgBackRest 2.25 (upcoming) commit log

Skip pg_internal.init temp file during backup. commit : cc743f2e04db05cc3277e43023ebd8e2007ef4ed author : David Steele <david@pgmasters.net> date : Fri, 21 Feb 2020 11:51:39 -0500 committer: David Steele <david@pgmasters.net> date : Fri, 21 Feb 2020 11:51:39 -0500 Click here for diff If PostgreSQL crashes it can leave behind a pg_internal.init temp file with the pid as the extension, as discussed in https://www.postgresql.org/message-id/flat/20200131045352.GB2631%40paquier.xyz#7700b9481ef5b0dd5f09cc410b4750f6. On restart this file is not cleaned up so it can persist for the lifetime of the cluster or until another process with the same id happens to write pg_internal.

PostgreSQL 12.3 (upcoming) commit log

Doc: Fix instructions to control build environment with MSVC commit : 4c95ce048327d465382f265303555ebf32e5dcd0 author : Michael Paquier <michael@paquier.xyz> date : Fri, 21 Feb 2020 12:05:36 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Fri, 21 Feb 2020 12:05:36 +0900 Click here for diff The documentation included some outdated instructions to change the architecture, build type or target OS of a build done with MSVC. This commit updates the documentation to include the modern options available, down to Visual Studio 2013.

PostgreSQL 11.8 (upcoming) commit log

Remove extra word from comment. commit : 2eadd00dd475e8f8731d67baf2a2296b8c13eeec author : Etsuro Fujita <efujita@postgresql.org> date : Thu, 20 Feb 2020 19:15:03 +0900 committer: Etsuro Fujita <efujita@postgresql.org> date : Thu, 20 Feb 2020 19:15:03 +0900 Click here for diff M src/backend/partitioning/partbounds.c Doc: discourage use of partial indexes for poor-man's-partitioning. commit : bbce2912fa899de30783a6a76a6443b5a2aede8d author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 18:52:18 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 18:52:18 -0500 Click here for diff

PostgreSQL 10.13 (upcoming) commit log

Doc: discourage use of partial indexes for poor-man's-partitioning. commit : 1de4a823f9dea3bdc2dba2fe0b9b90c06cfd6fbb author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 18:52:18 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 18:52:18 -0500 Click here for diff Creating a bunch of non-overlapping partial indexes is generally a bad idea, so add an example saying not to do that. Back-patch to v10. Before that, the alternative of using (real) partitioning wasn't available, so that the tradeoff isn't quite so clear cut.

PostgreSQL 9.5.22 (upcoming) commit log

Fix confusion about event trigger vs. plain function in plpgsql. commit : bbefb11541890d9add4b3b1ab2c53b26f4fc386b author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 14:44:58 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 14:44:58 -0500 Click here for diff The function hash table keys made by compute_function_hashkey() failed to distinguish event-trigger call context from regular call context. This meant that once we'd successfully made a hash entry for an event trigger (either by validation, or by normal use as an event trigger), an attempt to call the trigger function as a plain function would find this hash entry and thereby bypass the you-can't-do-that check in do_compile().

PostgreSQL 9.6.18 (upcoming) commit log

Fix confusion about event trigger vs. plain function in plpgsql. commit : 3e5308969aca4f2ce2dcd3766f9fe953b86b2a0c author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 14:44:58 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 19 Feb 2020 14:44:58 -0500 Click here for diff The function hash table keys made by compute_function_hashkey() failed to distinguish event-trigger call context from regular call context. This meant that once we'd successfully made a hash entry for an event trigger (either by validation, or by normal use as an event trigger), an attempt to call the trigger function as a plain function would find this hash entry and thereby bypass the you-can't-do-that check in do_compile().

PostgreSQL 13.0 (upcoming) commit log

Factor out InitControlFile() from BootStrapXLOG() commit : 79c2385915dd4aa43127e766c3dce323ec562ba0 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 17 Feb 2020 17:58:02 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 17 Feb 2020 17:58:02 +0100 Click here for diff Right now this only makes BootStrapXLOG() a bit more manageable, but in the future there may be external callers. Discussion: https://www.postgresql.org/message-id/e8f86ba5-48f1-a80a-7f1d-b76bcb9c5c47@2ndquadrant.com M src/backend/access/transam/xlog.c Reformat code comment commit : 9745f93afc56829f9cf10ca3e43a29f0b4409fe3 author : Peter Eisentraut <peter@eisentraut.

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.

PostgreSQL 11.7 commit log

Stamp 11.7. commit : a8423a99122bae8e90a3874a4466c39031657a55 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:17:28 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:17:28 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.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 : f1a336887e1cc754b4985c82827aa70f847980ba author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 12.2 commit log

Stamp 12.2. commit : 45b88269a353ad93744772791feb6d01bc7e1e42 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:14:51 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 17:14:51 -0500 Click here for diff M configure M configure.in M src/include/pg_config.h.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 : ce5a2d2c3e8e1353d1cb31ab143730accbb1ac75 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Feb 2020 12:51:07 -0500 committer: Tom Lane <tgl@sss.

pgBackRest 2.24 commit log

v2.23: Bug Fix commit : 2358d3448507f5dc4fd50edf65172285bca69c4b author : David Steele <david@pgmasters.net> date : Sun, 26 Jan 2020 22:38:21 -0700 committer: David Steele <david@pgmasters.net> date : Sun, 26 Jan 2020 22:38:21 -0700 Click here for diff Bug Fixes: * Fix missing files corrupting the manifest. If a file was removed by PostgreSQL during the backup (or was missing from the standby) then the next file might not be copied and updated in the manifest.

pgBackRest 2.23 commit log

v2.22: Bug Fix commit : bae6e1c9e3a035f3793739ef1b469015777aa70b author : David Steele <david@pgmasters.net> date : Tue, 21 Jan 2020 16:12:33 -0700 committer: David Steele <david@pgmasters.net> date : Tue, 21 Jan 2020 16:12:33 -0700 Click here for diff Bug Fixes: * Fix error in timeline conversion. The timeline is required to verify WAL segments in the archive after a backup. The conversion was performed base 10 instead of 16, which led to errors when the timeline was ≥ 0xA.

pgBackRest 2.22 commit log

v2.21: C Migration Complete commit : 2c0ba0820d3e4adea31ef6b8ee201be653ef9579 author : David Steele <david@pgmasters.net> date : Wed, 15 Jan 2020 13:21:52 -0700 committer: David Steele <david@pgmasters.net> date : Wed, 15 Jan 2020 13:21:52 -0700 Click here for diff Bug Fixes: * Fix options being ignored by asynchronous commands. The asynchronous archive-get/archive-push processes were not loading options configured in command configuration sections, e.g. [global:archive-get]. (Reviewed by Cynthia Shang. Reported by Urs Kramer.) * Fix handling of \ in filenames.

pgBackRest 2.21 commit log

v2.20: Bug Fixes commit : 39fc2b7ad68d97cf5f23757e8a341428935621f4 author : David Steele <david@pgmasters.net> date : Thu, 12 Dec 2019 08:20:21 -0500 committer: David Steele <david@pgmasters.net> date : Thu, 12 Dec 2019 08:20:21 -0500 Click here for diff Bug Fixes: * Fix archive-push/archive-get when PGDATA is symlinked. These commands tried to use cwd() as PGDATA but this would disagree with the path configured in pgBackRest if PGDATA was symlinked. If cwd() does not match the pgBackRest path then chdir() to the path and make sure the next cwd() matches the result from the first call.

pgBackRest 2.20 commit log

v2.19: C Migrations and Bug Fixes commit : 2d10293d041cbbc72e4a2bac32401f6f384ecb1a author : David Steele <david@pgmasters.net> date : Tue, 12 Nov 2019 15:51:28 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Nov 2019 15:51:28 -0500 Click here for diff Bug Fixes: * Fix remote timeout in delta restore. When performing a delta restore on a largely unchanged cluster the remote could timeout if no files were fetched from the repository within protocol-timeout.

PostgreSQL 9.4.25 commit log

Stamp 9.4.25. commit : 6cd154923526141ee65548513324fa66c72e83d4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:13:41 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:13:41 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 84aad60b9cdade0a9d55f938bec92d788e2c54e9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.20 commit log

Stamp 9.5.20. commit : 2b634067fcd0c3ac6d528b261b4c77d97e6aeae2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:11:27 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:11:27 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 18831346d4e607d35ff338c6e9eec0319cff8d72 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.16 commit log

Stamp 9.6.16. commit : 39b3a8c830097af84f655a36879eb1b686fb4cd7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:09:28 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:09:28 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 750d72fde6233b4ccad5f5416b68042169c97b61 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 10.11 commit log

Stamp 10.11. commit : 004ae0a9766236d5d1769301089a014c5ef09cae author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:07:14 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:07:14 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : b75667d84fb3f96418dcef4e464ad0dab97237b6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 11.6 commit log

Stamp 11.6. commit : 34f805c8cf1bc4d54075526d3b023d9194ccd2cd author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:05:05 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:05:05 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : b3c762a45a14e119acf371f60eb01c8d3607f714 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 12.1 commit log

Stamp 12.1. commit : 578a551f82f7ad746b36d98c401bdc92c136d664 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:03:10 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:03:10 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 02f7b7ab75680440695a1e205cbb6636551b6013 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.