Life with Open Source

PostgreSQL 10.15 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : a950fb0734267ebdc48e3a03b234b42f81135a9e author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

PostgreSQL 11.10 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : cc7b27da7fb884f2d69c96b8c9a0e299b4078e29 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

PostgreSQL 12.5 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : 1af91dc032cfc3f1e47d3bbb976ad6c880668bad author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

PostgreSQL 13.0 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : 9ab5ed4194f3863ff744e195027da747d4db4106 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

PostgreSQL 9.5.24 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : 760b8fe766bce62fa00fb22dc60315418288a1a8 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

PostgreSQL 9.6.20 (upcoming) commit log

Use factorial rather than numeric_fac in create_operator.sql. commit : 1e00333ffa2eebd4cd76526dbd087bee3b96a015 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 18 Sep 2020 18:03:44 -0400 Click here for diff These two SQL functions are aliases for the same C function, so this change has no semantic effect. However, because we dropped the numeric_fac alias in HEAD (commit 76f412ab3), operator definitions based on that one don't port forward, causing problems for cross-version upgrade tests based on the regression database.

pgBackRest 2.31 (upcoming) commit log

Improve PostgreSQL version identification. commit : 927d9adbee780a51639955edb74ce7a4850db100 author : David Steele <dwsteele@users.noreply.github.com> date : Fri, 18 Sep 2020 16:55:26 -0400 committer: GitHub <noreply@github.com> date : Fri, 18 Sep 2020 16:55:26 -0400 Click here for diff Previously, catalog versions were fixed for all versions which made maintaining the catalog versions during PostgreSQL beta and release candidate cycles very painful. A version of pgBackRest which was functionally compatible was rendered useless by a catalog version bump in PostgreSQL.

pgAudit 1.1.3 (upcoming) commit log

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.net> date : Wed, 9 Sep 2020 09:59:23 -0400 Click here for diff M README.md Fix "pgaudit stack is not empty" error. commit : 83333e2c166e3ba03f24a0f99d47d8d024b494a0 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:40:32 -0400 committer: David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:40:32 -0400 Click here for diff

pgAudit 1.2.2 (upcoming) commit log

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.net> date : Wed, 9 Sep 2020 09:57:54 -0400 Click here for diff M README.md Fix "pgaudit stack is not empty" error. commit : c9b745a64eab5dadb6aabfeb1d9525a28d8a8096 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:34:54 -0400 committer: David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:34:54 -0400 Click here for diff

pgAudit 1.3.2 (upcoming) commit log

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.net> date : Wed, 9 Sep 2020 09:57:12 -0400 Click here for diff M README.md Fix "pgaudit stack is not empty" error. commit : 671dd2a628e3ea7bc56f662c9b07d574546f5aeb author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:32:13 -0400 committer: David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 08:32:13 -0400 Click here for diff

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.

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.

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.