Life with Open Source

PostgreSQL 16.0 (upcoming) commit log

Use lower case for icu_validation_level values commit : 0ffbe6e59197e5e2b3bf026f594fabb8ada9bec3 author : Peter Eisentraut <peter@eisentraut.org> date : Tue, 23 May 2023 15:19:33 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Tue, 23 May 2023 15:19:33 +0200 Click here for diff Similar to client_min_messages etc. M src/backend/utils/misc/postgresql.conf.sample Punctuation improvement in postgresql.conf.sample commit : dfe0169988f32e7cb9c48fad9ab3de71c6c39a55 author : Peter Eisentraut <peter@eisentraut.org> date : Tue, 23 May 2023 15:19:12 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Tue, 23 May 2023 15:19:12 +0200 Click here for diff

pgBackRest 2.48 (upcoming) commit log

Begin v2.47 development. commit : 9dbf76d8e87287786f03b65c94305b3dc126029b author : David Steele <david@pgmasters.net> date : Mon, 22 May 2023 11:19:00 +0300 committer: David Steele <david@pgmasters.net> date : Mon, 22 May 2023 11:19:00 +0300 Click here for diff M doc/resource/git-history.cache M doc/xml/release.xml M meson.build M src/build/configure.ac M src/configure M src/version.h

pgBackRest 2.47 commit log

v2.46: Block Incremental Backup and SFTP Storage commit : b461f7c6f884dba8056858464d1b571e708dad77 author : David Steele <david@pgmasters.net> date : Mon, 22 May 2023 11:13:13 +0300 committer: David Steele <david@pgmasters.net> date : Mon, 22 May 2023 11:13:13 +0300 Click here for diff Features: * Block incremental backup. (Reviewed by John Morris, Stephen Frost, Stefan Fercot.) * SFTP support for repository storage. (Contributed by Reid Thompson. Reviewed by Stephen Frost, David Steele.) * PostgreSQL 16 support.

PostgreSQL 12.16 (upcoming) commit log

Fix misbehavior of EvalPlanQual checks with multiple result relations. commit : ff77d8687fa3cee525fbfcf6b50b685c1ab8feab author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 Click here for diff The idea of EvalPlanQual is that we replace the query's scan of the result relation with a single injected tuple, and see if we get a tuple out, thereby implying that the injected tuple still passes the query quals.

PostgreSQL 13.0 (upcoming) commit log

Fix misbehavior of EvalPlanQual checks with multiple result relations. commit : 956c6256a98efcb53e982eb670a68658d3a38874 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 Click here for diff The idea of EvalPlanQual is that we replace the query's scan of the result relation with a single injected tuple, and see if we get a tuple out, thereby implying that the injected tuple still passes the query quals.

PostgreSQL 14.0 (upcoming) commit log

Fix misbehavior of EvalPlanQual checks with multiple result relations. commit : f8320cc72ddb91182c43ea23e2a721e10daa9b13 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 Click here for diff The idea of EvalPlanQual is that we replace the query's scan of the result relation with a single injected tuple, and see if we get a tuple out, thereby implying that the injected tuple still passes the query quals.

PostgreSQL 15.0 (upcoming) commit log

Fix misbehavior of EvalPlanQual checks with multiple result relations. commit : 4729d1e8aab90bc5861a4ff01fc306ebf1bec433 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 14:26:34 -0400 Click here for diff The idea of EvalPlanQual is that we replace the query's scan of the result relation with a single injected tuple, and see if we get a tuple out, thereby implying that the injected tuple still passes the query quals.

PostgreSQL 11.21 (upcoming) commit log

Avoid naming conflict between transactions.sql and namespace.sql. commit : 6f1cf2efbd0199c58db9f256ade48f42f56cab49 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 10:57:46 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 19 May 2023 10:57:46 -0400 Click here for diff Commits 681d9e462 et al added a test case in namespace.sql that implicitly relied on there not being a table "public.abc". However, the concurrently-run transactions.sql test creates precisely such a table, so with the right timing you'd get a failure.

PostgreSQL 11.20 commit log

Stamp 11.20. commit : f96e531b1c079ae148b927a204845c7150a573f8 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 17:21:16 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 17:21: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 : 8dec3e375380dcdffea20d95ce3993c1bf79b045 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 12:38:08 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.15 commit log

Stamp 12.15. commit : 117dd58fd9cd01e661a2c36977e16a2722306a6d author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 17:19:25 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 17:19:25 -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 : 666bc999e9e0ecccb00140e370f03c5f52a91d16 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 12:38:08 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 May 2023 12:38:08 -0400 Click here for diff

pgAudit 1.3.6 (upcoming) commit log

Update Github action/checkout to new version. commit : 136b275968c8c42dbe20cacb84f7a80f0fe416e7 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 Click here for diff This removes the deprecation warning. M .github/workflows/test.yml Explicitly install pg_statements in Makefile. commit : 47edccac164d451181180a3d6f05cfee0962d9e3 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 Click here for diff

pgAudit 1.4.5 (upcoming) commit log

Update Github action/checkout to new version. commit : 1d07ac4851fe5c26a13935b29971f6f4c1ad32e1 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 Click here for diff This removes the deprecation warning. M .github/workflows/test.yml Explicitly install pg_statements in Makefile. commit : 70be4e2792c10136ab78eeb0ca0b47babcb57207 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 Click here for diff

pgAudit 1.5.4 (upcoming) commit log

Update Github action/checkout to new version. commit : 1d07ac4851fe5c26a13935b29971f6f4c1ad32e1 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 Click here for diff This removes the deprecation warning. M .github/workflows/test.yml Explicitly install pg_statements in Makefile. commit : 70be4e2792c10136ab78eeb0ca0b47babcb57207 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 Click here for diff

pgAudit 1.6.4 (upcoming) commit log

Update Github action/checkout to new version. commit : 1d07ac4851fe5c26a13935b29971f6f4c1ad32e1 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:31:50 +0300 Click here for diff This removes the deprecation warning. M .github/workflows/test.yml Explicitly install pg_statements in Makefile. commit : 70be4e2792c10136ab78eeb0ca0b47babcb57207 author : David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 committer: David Steele <david@pgmasters.net> date : Thu, 27 Apr 2023 22:18:23 +0300 Click here for diff

pgBackRest 2.46 commit log

v2.45: Block Incremental Backup (BETA) commit : 6ad79d16ca638b7ccdc81b5530a39007b8e01aed author : David Steele <david@pgmasters.net> date : Mon, 20 Mar 2023 09:37:23 +0800 committer: David Steele <david@pgmasters.net> date : Mon, 20 Mar 2023 09:37:23 +0800 Click here for diff Bug Fixes: * Skip writing recovery.signal by default for restores of offline backups. (Reviewed by Stefan Fercot. Reported by Marcel Borger.) Features: * Block incremental backup (BETA). (Reviewed by John Morris, Stephen Frost, Stefan Fercot.

PostgreSQL 11.19 commit log

Stamp 11.19. commit : 0da63ea07a3b610a5f0c4fc43595d76f3d8fa0d7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 16:46:39 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 16:46:39 -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 Translation updates commit : f280ad2ca2d808a8cee6489dbbe2ec1e9ca02434 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 6 Feb 2023 12:22:35 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 6 Feb 2023 12:22:35 +0100 Click here for diff

PostgreSQL 12.14 commit log

Stamp 12.14. commit : 533cc39b750bd7600e8e2e5cab819a27f1717960 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 16:45:00 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 16:45:00 -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 : bd46d1b5413d52af224db982de79f429a0cf12de author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 11:43:10 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 Feb 2023 11:43:10 -0500 Click here for diff

pgBackRest 2.45 commit log

v2.44: Remove PostgreSQL 9.0/9.1/9.2 Support commit : 053468bfb156a8ecbd5d0325d35141056c89ec52 author : David Steele <david@pgmasters.net> date : Mon, 30 Jan 2023 09:15:44 +0700 committer: David Steele <david@pgmasters.net> date : Mon, 30 Jan 2023 09:15:44 +0700 Click here for diff Improvements: * Remove support for PostgreSQL 9.0/9.1/9.2. (Reviewed by Stefan Fercot.) * Restore errors when no backup matches the current version of PostgreSQL. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Soulou.

pgBackRest 2.44 commit log

v2.43: Bug Fix commit : cc2ffd8264bb4e10e6b289ce3978452018f725e8 author : David Steele <david@pgmasters.net> date : Mon, 28 Nov 2022 17:47:48 +0800 committer: David Steele <david@pgmasters.net> date : Mon, 28 Nov 2022 17:47:48 +0800 Click here for diff Bug Fixes: * Fix missing reference in diff/incr backup. (Reviewed by Stefan Fercot. Reported by Marcel Borger, ulfedf, jaymefSO.) Improvements: * Add hint when an option is specified without an index. (Reviewed by Stefan Fercot.) M CONTRIBUTING.

pgBackRest 2.43 commit log

v2.42: Bug Fixes commit : 70b75532bf20a025323b2a3138497ef01eb1774f author : David Steele <david@pgmasters.net> date : Tue, 22 Nov 2022 10:20:59 +0800 committer: David Steele <david@pgmasters.net> date : Tue, 22 Nov 2022 10:20:59 +0800 Click here for diff Bug Fixes: * Fix memory leak in file bundle backup/restore. (Reviewed by John Morris, Oscar. Reported by Oscar.) * Fix protocol error on short read of remote file. (Reviewed by Stephen Frost.) Improvements: * Do not store references for zero-length files when bundling.

PostgreSQL 10.24 (upcoming) commit log

Account for IPC::Run::result() Windows behavior change. commit : ec6ba191ce5aba32606171b2bda0d73b53381af0 author : Noah Misch <noah@leadboat.com> date : Thu, 17 Nov 2022 07:35:06 -0800 committer: Noah Misch <noah@leadboat.com> date : Thu, 17 Nov 2022 07:35:06 -0800 Click here for diff This restores compatibility with the not-yet-released successor of version 20220807.0. Back-patch to 9.4, which introduced this code. Reviewed by Andrew Dunstan. Discussion: https://postgr.es/m/20221117061805.GA4020280@rfd.leadboat.com M src/test/perl/TestLib.pm Fix compilation warnings with libselinux 3.1 in contrib/sepgsql/ commit : 8f5d4ee6c5a1de2601934139c974bc09bc42edab author : Michael Paquier <michael@paquier.

PostgreSQL 10.23 commit log

Stamp 10.23. commit : 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:51:10 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:51:10 -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 Translation updates commit : d26829e3f76ac58872bd57374cce6bd41d1e40cf author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:50:33 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:50:33 +0100 Click here for diff

PostgreSQL 11.18 commit log

Stamp 11.18. commit : eb3ff8600bd313071838ab376dd5c35524937242 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:49:11 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:49: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 Translation updates commit : 953a0346f43cbd69bef85513765d7cc621ac81e7 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:52:22 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:52:22 +0100 Click here for diff

PostgreSQL 12.13 commit log

Stamp 12.13. commit : 26b9b5dddfa21ce73d9b99e79e2336c5584745bd author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:47:13 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Nov 2022 16:47:13 -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 Translation updates commit : 81b2ffdb32385366aa45b13e669b7d1291770af0 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:55:08 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Nov 2022 13:55:08 +0100 Click here for diff

pgBackRest 2.42 commit log

v2.41: Backup Annotations commit : 6b355806cc288e6f473254412337596287291798 author : David Steele <david@pgmasters.net> date : Mon, 19 Sep 2022 10:08:10 -0700 committer: David Steele <david@pgmasters.net> date : Mon, 19 Sep 2022 10:08:10 -0700 Click here for diff Bug Fixes: * Fix incorrect time expiration being used for non-default repositories. (Reviewed by Stefan Fercot. Reported by Adam Brusselback.) * Fix issue when listing directories recursively with a filter. (Reviewed by Stephen Frost. Reported by Efremov Egor.