Life with Open Source

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.

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.

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.

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.

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.

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.

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

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.

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

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

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.

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

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

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

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

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.

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.

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.

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

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

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

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.

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.

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.

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