Life with Open Source

PostgreSQL 12.6 (upcoming) commit log

Fix CLUSTER progress reporting of number of blocks scanned. commit : fce17e486f3579fd2617c12f332608a5e78fefac author : Fujii Masao <fujii@postgresql.org> date : Fri, 27 Nov 2020 20:16:44 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Fri, 27 Nov 2020 20:16:44 +0900 Click here for diff Previously pg_stat_progress_cluster view reported the current block number in heap scan as the number of heap blocks scanned (i.e., heap_blks_scanned). This reported number could be incorrect when synchronize_seqscans is enabled, because it allowed the heap scan to start at block in middle.

PostgreSQL 13.0 (upcoming) commit log

Fix CLUSTER progress reporting of number of blocks scanned. commit : dcc20946a8fc192a71cedcaae25c996973747ff5 author : Fujii Masao <fujii@postgresql.org> date : Fri, 27 Nov 2020 20:16:44 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Fri, 27 Nov 2020 20:16:44 +0900 Click here for diff Previously pg_stat_progress_cluster view reported the current block number in heap scan as the number of heap blocks scanned (i.e., heap_blks_scanned). This reported number could be incorrect when synchronize_seqscans is enabled, because it allowed the heap scan to start at block in middle.

PostgreSQL 10.16 (upcoming) commit log

doc: Fix typos commit : d965f698dcbe05d07ec44ba95db94b9e483c8066 author : Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 Click here for diff Author: Justin Pryzby <pryzby@telsasoft.com> Discussion: https://www.postgresql.org/message-id/20201121194105.GO24784@telsasoft.com M doc/src/sgml/contrib.sgml Properly check index mark/restore in ExecSupportsMarkRestore. commit : 321c87e5ca1a8a766a55ec4201099a37b9b0c68b author : Andrew Gierth <rhodiumtoad@postgresql.org> date : Tue, 24 Nov 2020 20:58:32 +0000 committer: Andrew Gierth <rhodiumtoad@postgresql.

PostgreSQL 11.11 (upcoming) commit log

doc: Fix typos commit : b9a027c53a2a1efbe45413c83fc89412654a0d1c author : Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 Click here for diff Author: Justin Pryzby <pryzby@telsasoft.com> Discussion: https://www.postgresql.org/message-id/20201121194105.GO24784@telsasoft.com M doc/src/sgml/contrib.sgml Properly check index mark/restore in ExecSupportsMarkRestore. commit : 018e7d98dc157265efc4121e2b5971c0a2afcbe1 author : Andrew Gierth <rhodiumtoad@postgresql.org> date : Tue, 24 Nov 2020 20:58:32 +0000 committer: Andrew Gierth <rhodiumtoad@postgresql.

PostgreSQL 9.5.25 (upcoming) commit log

doc: Fix typos commit : 796f57d21697b2a9addfebae9d0182f2539b883e author : Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 Click here for diff Author: Justin Pryzby <pryzby@telsasoft.com> Discussion: https://www.postgresql.org/message-id/20201121194105.GO24784@telsasoft.com M doc/src/sgml/contrib.sgml Properly check index mark/restore in ExecSupportsMarkRestore. commit : 59ed45e278b78dbfae1b02ad90eee3d01ddec929 author : Andrew Gierth <rhodiumtoad@postgresql.org> date : Tue, 24 Nov 2020 20:58:32 +0000 committer: Andrew Gierth <rhodiumtoad@postgresql.

PostgreSQL 9.6.21 (upcoming) commit log

doc: Fix typos commit : 272ace098dd365b7aba2dfa93fbf35e1ba55d984 author : Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Wed, 25 Nov 2020 09:49:00 +0100 Click here for diff Author: Justin Pryzby <pryzby@telsasoft.com> Discussion: https://www.postgresql.org/message-id/20201121194105.GO24784@telsasoft.com M doc/src/sgml/contrib.sgml Properly check index mark/restore in ExecSupportsMarkRestore. commit : 6402afd9865e3218b1f3835108a1e156157b6e08 author : Andrew Gierth <rhodiumtoad@postgresql.org> date : Tue, 24 Nov 2020 20:58:32 +0000 committer: Andrew Gierth <rhodiumtoad@postgresql.

pgBackRest 2.32 (upcoming) commit log

Conform retry in lockAcquireFile() to the common retry pattern. commit : 3ed7b93b90eb61d40221701e0aef1318c1ea2b2b author : Cynthia Shang <cynthia.shang@crunchydata.com> date : Tue, 24 Nov 2020 09:40:44 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 24 Nov 2020 09:40:44 -0500 Click here for diff M doc/xml/release.xml M src/common/lock.c Prepare configuration module for multi-repository support. commit : 117f03eba15378cfa15097828041331b67d16f12 author : David Steele <david@pgmasters.net> date : Mon, 23 Nov 2020 15:55:46 -0500 committer: David Steele <david@pgmasters.

PostgreSQL 9.5.24 commit log

Stamp 9.5.24. commit : f57cc8693b15b79186684f02b729090a149b7555 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:34:09 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:34:09 -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 : d43ba1d84ccb74fd394c01ff23b033b26ab154c0 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:14 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.20 commit log

Stamp 9.6.20. commit : e4554425e6d3b429a207ac1a109af9d7e1d14da6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:32:22 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:32:22 -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 : 0425151233e018edfc03d2c3fe38f94ef3a67e77 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:14 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 10.15 commit log

Stamp 10.15. commit : e6c792ab72b99a3d68bf0696d0720e9afc61695c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:29:52 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:29:52 -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 : b0529799960e910c4cf1e3d5509572dc8c653d67 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 11.10 commit log

Stamp 11.10. commit : 7e0c8283c021abf15f24f217e6bcc7faf4860b34 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:28:11 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:28:11 -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 : cb2fffe0d627d3437737ab5293c435b302f6bccf author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 12.5 commit log

Stamp 12.5. commit : 6bb1b38fa5388a4aa39ed9e56ef477f618fb28e1 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:26:33 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:26:33 -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 Last-minute updates for release notes. commit : 0b59df670bd15065a87d1d9c216c3787839937fe author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

pgAudit 1.1.3 commit log

Stamp 1.1.3. commit : edab09603f2b9e25d2c3f7799400b1e7208ce40b author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 16:10:58 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 16:10:58 -0400 Click here for diff M Makefile A pgaudit–1.1.2–1.1.3.sql R094 pgaudit–1.1.2.sql pgaudit–1.1.3.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : 766c773e9329c98ebf993ccc3b022cbc6866848a author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:59:23 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.2.2 commit log

Stamp 1.2.2. commit : 8178fc31cf758ccec7c1c9f7c21d1f6f41a4753b author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:57:06 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:57:06 -0400 Click here for diff M Makefile A pgaudit–1.2.1–1.2.2.sql R094 pgaudit–1.2.1.sql pgaudit–1.2.2.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : 33121cd796d4538e1690439f6ec5b6a3e4445d67 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:57:54 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.3.2 commit log

Stamp 1.3.2. commit : 08e259ae81e337d3b2bd2ef837d216b05b3348b7 author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:44:09 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:44:09 -0400 Click here for diff M Makefile A pgaudit–1.3.1–1.3.2.sql R094 pgaudit–1.3.1.sql pgaudit–1.3.2.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : cda5efecbd0d8b2824351c0c49d0c44a7dc2ce63 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:57:12 -0400 committer: David Steele <david@pgmasters.

pgBackRest 2.31 commit log

v2.30: PostgreSQL 13 Support commit : 9229d6c866ee6296180bfefdbce42660b9e59b98 author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 11:51:45 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 11:51:45 -0400 Click here for diff Bug Fixes: * Error with hints when backup user cannot read pg_settings. (Reviewed by Stefan Fercot, Cynthia Shang. Reported by Mohamed Insaf K.) Features: * PostgreSQL 13 support. (Reviewed by Cynthia Shang.) Improvements: * Improve PostgreSQL version identification.

pgBackRest 2.30 commit log

v2.29: Auto S3 Credentials on AWS commit : 1df7d3eee5baa38504478fafa27de2b1b0fce724 author : David Steele <david@pgmasters.net> date : Mon, 31 Aug 2020 07:28:22 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 31 Aug 2020 07:28:22 -0400 Click here for diff Bug Fixes: * Suppress errors when closing local/remote processes. Since the command has completed it is counterproductive to throw an error but still warn to indicate that something unusual happened. (Reviewed by Cynthia Shang.

PostgreSQL 9.5.23 commit log

Stamp 9.5.23. commit : 641d7cf4bc92499fdbf23f3b47112502d5720599 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:23:10 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:23:10 -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 : 2e0358752da35d9c3496a5b448983d0ebd0ed9d9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.19 commit log

Stamp 9.6.19. commit : 03f5894b35c044f9b261bd00822ae4f009004871 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:21:12 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:21:12 -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 : a7e51a407658c65b3c3458bbbbff6c46a3c182b2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.14 commit log

Stamp 10.14. commit : a293b42e5274bb563fc10910272f30451f0857fb author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:19:16 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:19:16 -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 : d3aa1d4f48a49533cd3ea1dc845aefad89b60065 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.9 commit log

Stamp 11.9. commit : 25180875cb90ef18e83ce45697a9a4d4686b552b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:17:40 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:17: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 : 6f57b9bf39283b89808c45da360c748ab29535c6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.4 commit log

Stamp 12.4. commit : 0ad348f38ea9aaafe51f9197c8a2498aaec70ff1 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:15:53 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:15:53 -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 : f9ddc36ed676eb008f7392608fe250387968685e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.