Life with Open Source

PostgreSQL 15.0 (upcoming) commit log

Save a few bytes in pg_attribute commit : 90189eefc1e11822794e3386d9bafafd3ba3a6e8 author : Peter Eisentraut <peter@eisentraut.org> date : Tue, 28 Mar 2023 09:58:14 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Tue, 28 Mar 2023 09:58:14 +0200 Click here for diff Change the columns attndims, attstattarget, and attinhcount from int32 to int16, and reorder a bit. This saves some space (currently 4 bytes) in pg_attribute and tuple descriptors, which translates into small performance benefits and/or room for new columns in pg_attribute needed by future features.

PostgreSQL 16.0 (upcoming) commit log

Save a few bytes in pg_attribute commit : 90189eefc1e11822794e3386d9bafafd3ba3a6e8 author : Peter Eisentraut <peter@eisentraut.org> date : Tue, 28 Mar 2023 09:58:14 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Tue, 28 Mar 2023 09:58:14 +0200 Click here for diff Change the columns attndims, attstattarget, and attinhcount from int32 to int16, and reorder a bit. This saves some space (currently 4 bytes) in pg_attribute and tuple descriptors, which translates into small performance benefits and/or room for new columns in pg_attribute needed by future features.

PostgreSQL 11.20 (upcoming) commit log

doc: Fix XML_CATALOG_FILES env var for Apple Silicon machines commit : 4257d34e310be2e16c782f9e9339907a34f708ce author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:34 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:34 +0200 Click here for diff Homebrew changed the prefix for Apple Silicon based machines, so our advice for XML_CATALOG_FILES needs to mention both. More info on the Homebrew change can be found at: https://github.com/Homebrew/brew/issues/9177 This is backpatch of commits 4c8d65408 and 5a91c7975, the latter which contained a small fix based on a report from Dagfinn Ilmari Mannsåker.

PostgreSQL 12.15 (upcoming) commit log

doc: Fix XML_CATALOG_FILES env var for Apple Silicon machines commit : aad9a2ee7c2d381bfa3317ecfb2cd28601b0aa19 author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:30 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:30 +0200 Click here for diff Homebrew changed the prefix for Apple Silicon based machines, so our advice for XML_CATALOG_FILES needs to mention both. More info on the Homebrew change can be found at: https://github.com/Homebrew/brew/issues/9177 This is backpatch of commits 4c8d65408 and 5a91c7975, the latter which contained a small fix based on a report from Dagfinn Ilmari Mannsåker.

PostgreSQL 14.0 (upcoming) commit log

doc: Fix XML_CATALOG_FILES env var for Apple Silicon machines commit : c6f1f4e443fb8f8843c33727ea19bb677aec8074 author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:27 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:27 +0200 Click here for diff Homebrew changed the prefix for Apple Silicon based machines, so our advice for XML_CATALOG_FILES needs to mention both. More info on the Homebrew change can be found at: https://github.com/Homebrew/brew/issues/9177 This is backpatch of commits 4c8d65408 and 5a91c7975, the latter which contained a small fix based on a report from Dagfinn Ilmari Mannsåker.

PostgreSQL 13.0 (upcoming) commit log

doc: Fix XML_CATALOG_FILES env var for Apple Silicon machines commit : 9850ef9fc123e479562011ae308bdabe5bfc04c3 author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:24 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 27 Mar 2023 21:35:24 +0200 Click here for diff Homebrew changed the prefix for Apple Silicon based machines, so our advice for XML_CATALOG_FILES needs to mention both. More info on the Homebrew change can be found at: https://github.com/Homebrew/brew/issues/9177 This is backpatch of commits 4c8d65408 and 5a91c7975, the latter which contained a small fix based on a report from Dagfinn Ilmari Mannsåker.

pgBackRest 2.47 (upcoming) commit log

Add reference filter and output to manifest command. commit : c8ec114c8cb392d227fa267c62d11cc6b4fb9677 author : David Steele <david@pgmasters.net> date : Tue, 21 Mar 2023 12:29:45 +0800 committer: David Steele <david@pgmasters.net> date : Tue, 21 Mar 2023 12:29:45 +0800 Click here for diff This allows the file list to be filtered by reference. The reference is output when it is not the default reference for the backup. M doc/xml/release.xml M src/build/config/config.yaml M src/build/help/help.xml

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.

pgAudit 1.3.6 (upcoming) commit log

Update copyright end year. commit : e24d3422f0c238a85f81e21e9e3c4d5900394d94 author : David Youatt <youattdp@gmail.com> date : Wed, 4 Jan 2023 01:31:31 -0800 committer: David Steele <david@pgmasters.net> date : Wed, 4 Jan 2023 01:31:31 -0800 Click here for diff M pgaudit.c Add caveat about auditing the superuser. commit : 25f5657d718d5aab5b0b29b9f1727fbeda4a7b4b author : David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:36:44 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:36:44 -0400 Click here for diff

pgAudit 1.4.5 (upcoming) commit log

Update copyright end year. commit : c8630ddc41c56ee693c934a898225a60891204a6 author : David Youatt <youattdp@gmail.com> date : Wed, 4 Jan 2023 01:31:31 -0800 committer: GitHub <noreply@github.com> date : Wed, 4 Jan 2023 01:31:31 -0800 Click here for diff M pgaudit.c Add caveat about auditing superusers. commit : 8349710fbbe38ca9518ebe753a528b94f5ab2c19 author : David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 Click here for diff

pgAudit 1.5.4 (upcoming) commit log

Update copyright end year. commit : c8630ddc41c56ee693c934a898225a60891204a6 author : David Youatt <youattdp@gmail.com> date : Wed, 4 Jan 2023 01:31:31 -0800 committer: GitHub <noreply@github.com> date : Wed, 4 Jan 2023 01:31:31 -0800 Click here for diff M pgaudit.c Add caveat about auditing superusers. commit : 8349710fbbe38ca9518ebe753a528b94f5ab2c19 author : David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 Click here for diff

pgAudit 1.6.4 (upcoming) commit log

Update copyright end year. commit : c8630ddc41c56ee693c934a898225a60891204a6 author : David Youatt <youattdp@gmail.com> date : Wed, 4 Jan 2023 01:31:31 -0800 committer: GitHub <noreply@github.com> date : Wed, 4 Jan 2023 01:31:31 -0800 Click here for diff M pgaudit.c Add caveat about auditing superusers. commit : 8349710fbbe38ca9518ebe753a528b94f5ab2c19 author : David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:32:06 -0400 Click here for diff

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.

PostgreSQL 10.22 commit log

Stamp 10.22. commit : c8b932112db2589bd9bb12d120f09fa29ab1f080 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:50:46 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:50:46 -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 Stabilize output of new regression test. commit : 2d7d8f4397c5855e9159c05a2afb131c34282a8f author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 12:16:01 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.17 commit log

Stamp 11.17. commit : 866f915688b02294275d8791828dca3442cbeb78 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:49:00 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:49:00 -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 Stabilize output of new regression test. commit : 4c1dd680267f0bc56de8fb2a138aa556054f9886 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 12:16:01 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.12 commit log

Stamp 12.12. commit : 7cd0d523d2581895e65cd0ebebc7e50caa8bbfda author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:47:33 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 16:47:33 -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 Stabilize output of new regression test. commit : dfab37100de1127595b4f1f6949137bfea355c22 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 12:16:01 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Aug 2022 12:16:01 -0400 Click here for diff