Life with Open Source

PostgreSQL 13.0 (upcoming) commit log

doc: Update the layout of "Viewing Statistics" section. commit : 92f9468657f0916ce8589e13d5ebda60c7973c31 author : Fujii Masao <fujii@postgresql.org> date : Fri, 29 May 2020 17:14:33 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Fri, 29 May 2020 17:14:33 +0900 Click here for diff This commit updates the "Viewing Statistics" section more like the existing catalogs chapter. - Change its layout so that an introductory paragrap is put above the table for each statistics view.

PostgreSQL 11.9 (upcoming) commit log

llvmjit: Fix building against LLVM 11 by removing unnecessary include. commit : c001c115bcb2accddc23a25c605886e01475db4f author : Andres Freund <andres@anarazel.de> date : Thu, 28 May 2020 15:08:12 -0700 committer: Andres Freund <andres@anarazel.de> date : Thu, 28 May 2020 15:08:12 -0700 Click here for diff LLVM has removed this header, in the branch that will become llvm 11. But as it turns out we didn't actually need it, so just remove it. Author: Jesse Zhang <sbjesse@gmail.

PostgreSQL 12.4 (upcoming) commit log

llvmjit: Fix building against LLVM 11 by removing unnecessary include. commit : 59e390cac97555e54457874ef27092012cb48b18 author : Andres Freund <andres@anarazel.de> date : Thu, 28 May 2020 15:08:12 -0700 committer: Andres Freund <andres@anarazel.de> date : Thu, 28 May 2020 15:08:12 -0700 Click here for diff LLVM has removed this header, in the branch that will become llvm 11. But as it turns out we didn't actually need it, so just remove it. Author: Jesse Zhang <sbjesse@gmail.

PostgreSQL 9.5.23 (upcoming) commit log

Initialize dblink remoteConn struct in all cases commit : f140d9b6e0aff91e07b7dd80cf0915bb19f02a9c author : Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:15 -0400 committer: Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:15 -0400 Click here for diff Two of the members of rconn were left uninitialized. When dblink_open() is called without an outer transaction it handles the initialization for us, but with an outer transaction it does not.

PostgreSQL 9.6.19 (upcoming) commit log

Initialize dblink remoteConn struct in all cases commit : 43d7934a3a9291aac6d3c713107bdac059062e0d author : Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:11 -0400 committer: Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:11 -0400 Click here for diff Two of the members of rconn were left uninitialized. When dblink_open() is called without an outer transaction it handles the initialization for us, but with an outer transaction it does not.

PostgreSQL 10.14 (upcoming) commit log

Initialize dblink remoteConn struct in all cases commit : 43d3d73189fd7ee877a65d810a98c1022ba368b7 author : Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:06 -0400 committer: Joe Conway <mail@joeconway.com> date : Thu, 28 May 2020 13:45:06 -0400 Click here for diff Two of the members of rconn were left uninitialized. When dblink_open() is called without an outer transaction it handles the initialization for us, but with an outer transaction it does not.

pgBackRest 2.29 (upcoming) commit log

Remove exclamations from test data. commit : fe829af4ece88afabc026e876250fc04851bb51c author : David Steele <david@pgmasters.net> date : Thu, 28 May 2020 10:27:45 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 28 May 2020 10:27:45 -0400 Click here for diff Three exclamations are commonly used to mark areas of the code that need attention before commit so having them in a test is distracting. M test/src/module/command/backupTest.c Add missing parameter logging. commit : 28676e1707a36e273b7f236d495b3e611a06328d author : David Steele <david@pgmasters.

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.

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.