Life with Open Source

PostgreSQL 13.0 (upcoming) commit log

Restructure ALTER TABLE execution to fix assorted bugs. commit : 1281a5c907b41e992a66deb13c3aa61888a62268 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 15 Jan 2020 18:49:24 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 15 Jan 2020 18:49:24 -0500 Click here for diff We've had numerous bug reports about how (1) IF NOT EXISTS clauses in ALTER TABLE don't behave as-expected, and (2) combining certain actions into one ALTER TABLE doesn't work, though executing the same actions as separate statements does.

pgBackRest 2.23 (upcoming) commit log

Reclassify Perl and LibC code as test/harness. commit : e81629b4420759f80bd18017ee47b89942c90090 author : David Steele <david@pgmasters.net> date : Wed, 15 Jan 2020 13:53:30 -0700 committer: David Steele <david@pgmasters.net> date : Wed, 15 Jan 2020 13:53:30 -0700 Click here for diff These were still being included in the core totals but they are no longer used by core. M test/code-count/file-type.yaml M test/lib/pgBackRestTest/Common/CodeCountTest.pm Remove -s from make instructions. commit : 193b78e150919470b33f3941be03f0ef589a3e79 author : David Steele <david@pgmasters.

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.

PostgreSQL 11.7 (upcoming) commit log

Fix buggy logic in isTempNamespaceInUse() commit : 5ec7bd819c5081d46a7e3bde60dcf7c01d7b8af9 author : Michael Paquier <michael@paquier.xyz> date : Wed, 15 Jan 2020 13:58:46 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Wed, 15 Jan 2020 13:58:46 +0900 Click here for diff The logic introduced in this routine as of 246a6c8 would report an incorrect result when a session calls it to check if the temporary namespace owned by the session is in use or not.

PostgreSQL 12.2 (upcoming) commit log

Fix buggy logic in isTempNamespaceInUse() commit : 0fca3d0a4ec297bff5a5cb01dfe345e0f63d7d63 author : Michael Paquier <michael@paquier.xyz> date : Wed, 15 Jan 2020 13:58:41 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Wed, 15 Jan 2020 13:58:41 +0900 Click here for diff The logic introduced in this routine as of 246a6c8 would report an incorrect result when a session calls it to check if the temporary namespace owned by the session is in use or not.

PostgreSQL 10.12 (upcoming) commit log

docs: change "default role" wording to "predefined role" commit : 920c6add70c803ae1dcaab9358330320a60de470 author : Bruce Momjian <bruce@momjian.us> date : Tue, 14 Jan 2020 13:13:04 -0500 committer: Bruce Momjian <bruce@momjian.us> date : Tue, 14 Jan 2020 13:13:04 -0500 Click here for diff The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rirans@comcast.net Discussion: https://postgr.es/m/157742545062.1149.11052653770497832538@wrigleys.postgresql.org Backpatch-through: 9.6 M doc/src/sgml/user-manag.sgml Make rewriter prevent auto-updates on views with conditional INSTEAD rules.

PostgreSQL 9.6.17 (upcoming) commit log

docs: change "default role" wording to "predefined role" commit : 90d553dd96106ab278550e85d95a5663d77d7db7 author : Bruce Momjian <bruce@momjian.us> date : Tue, 14 Jan 2020 13:13:04 -0500 committer: Bruce Momjian <bruce@momjian.us> date : Tue, 14 Jan 2020 13:13:04 -0500 Click here for diff The new wording was determined to be more accurate. Also, update release note links that reference these sections. Reported-by: rirans@comcast.net Discussion: https://postgr.es/m/157742545062.1149.11052653770497832538@wrigleys.postgresql.org Backpatch-through: 9.6 M doc/src/sgml/release-9.6.sgml M doc/src/sgml/user-manag.sgml

PostgreSQL 9.5.21 (upcoming) commit log

Make rewriter prevent auto-updates on views with conditional INSTEAD rules. commit : bb09a9414f1e149aac6064d217b5d5cab8f13723 author : Dean Rasheed <dean.a.rasheed@gmail.com> date : Tue, 14 Jan 2020 09:48:44 +0000 committer: Dean Rasheed <dean.a.rasheed@gmail.com> date : Tue, 14 Jan 2020 09:48:44 +0000 Click here for diff A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the planner may fail to properly handle such a query and thus return a particularly unhelpful error to the user, before reaching the executor check.

PostgreSQL 9.4.26 (upcoming) commit log

Make rewriter prevent auto-updates on views with conditional INSTEAD rules. commit : 9be6fcb3e4e21c5d745dba314a451dc40f6f388b author : Dean Rasheed <dean.a.rasheed@gmail.com> date : Tue, 14 Jan 2020 09:47:44 +0000 committer: Dean Rasheed <dean.a.rasheed@gmail.com> date : Tue, 14 Jan 2020 09:47:44 +0000 Click here for diff A view with conditional INSTEAD rules and no unconditional INSTEAD rules or INSTEAD OF triggers is not auto-updatable. Previously we relied on a check in the executor to catch this, but that's problematic since the planner may fail to properly handle such a query and thus return a particularly unhelpful error to the user, before reaching the executor check.

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.

pgBackRest 2.19 commit log

v2.18: PostgreSQL 12 Support commit : 4629237d6a308a250cd52fff49693cd0a1069253 author : David Steele <david@pgmasters.net> date : Tue, 1 Oct 2019 16:02:07 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 1 Oct 2019 16:02:07 -0400 Click here for diff Features: * PostgreSQL 12 support. * Add info command set option for detailed text output. The additional details include databases that can be used for selective restore and a list of tablespaces and symlinks with their default destinations.

PostgreSQL 12.0 commit log

Stamp 12.0. commit : ad1f2885b8c82e0c2d56d7974f012cbecce17a17 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 30 Sep 2019 16:03:42 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 30 Sep 2019 16:03:42 -0400 Click here for diff M configure M configure.in M src/include/pg_config.h.win32 Suppress another CR in program output commit : b60f9afcf4bfe6b1ff73b49b9bab20dde356c7f4 author : Andrew Dunstan <andrew@dunslane.net> date : Mon, 30 Sep 2019 15:48:54 -0400 committer: Andrew Dunstan <andrew@dunslane.net> date : Mon, 30 Sep 2019 15:48:54 -0400 Click here for diff

pgBackRest 2.18 commit log

v2.17: C Migrations and Bug Fixes commit : ce2bf2999892f689001b084af4d5feb63dc9b402 author : David Steele <david@pgmasters.net> date : Tue, 3 Sep 2019 16:39:32 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 3 Sep 2019 16:39:32 -0400 Click here for diff Bug Fixes: * Improve slow manifest build for very large quantities of tables/segments. (Reported by Jens Wilke.) * Fix exclusions for special files. (Reported by CluelessTechnologist, Janis Puris, Rachid Broum.) Improvements: * The stanza-create/update/delete commands are implemented entirely in C.

PostgreSQL 9.4.24 commit log

Stamp 9.4.24. commit : 246893dce8ebea90ef083ab801da4d1f474e01ad author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:22:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:22:47 -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 : 4908df4a609aa1f2b3def968fe5b94a74cfde214 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.19 commit log

Stamp 9.5.19. commit : 167e5353799eabb034817b1e7bafd674d3c2bb04 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:20:40 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:20:40 -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 : e3d8c9a5f1014be97150d07b3e5af1d32a45df65 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.15 commit log

Stamp 9.6.15. commit : 86ca7f81f7dfc17f04698189dec8973d358bc711 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:18:48 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:18: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 Last-minute updates for release notes. commit : 3354bd5e2ba921d8267dbd6cac90b491a4f27cae author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.10 commit log

Stamp 10.10. commit : 2fbecb66c45eccb8922c371084ae4f0b3a72a86b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:16:54 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:16:54 -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 : f61bc0048b6b3a9bac7afd469cb6811d29d29d5d author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.5 commit log

Stamp 11.5. commit : fdf16779f107dd22a2cb8430d2eee6c344b34187 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:14:59 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:14:59 -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 : d03c0413343ac5a79bc2f6ee5abc84c873efd863 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.