Life with Open Source

PostgreSQL 15.0 (upcoming) commit log

doc: Clarify unit of logging for log_temp_files commit : 1f059a440864021b23b0667e7c0cb664710b660d author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 28 Nov 2022 11:10:01 +0100 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Mon, 28 Nov 2022 11:10:01 +0100 Click here for diff When the unit is omitted from log_temp_files the value is taken as kb, but the logged value is also without unit but specified in bytes. This could cause some confusion, so clarify in the documentation which unit is used when logging.

PostgreSQL 11.19 (upcoming) commit log

Fix binary mismatch for MSVC plperl vs gcc built perl libs commit : 724dd5649079a38193793c00292419917969effb author : Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 Click here for diff When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 0000000012800080, needed 0000000012900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl.

PostgreSQL 12.14 (upcoming) commit log

Fix binary mismatch for MSVC plperl vs gcc built perl libs commit : 85565cbcad4a78dab5a60c457b0f6e0a740539ce author : Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 Click here for diff When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 0000000012800080, needed 0000000012900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl.

PostgreSQL 13.0 (upcoming) commit log

Fix binary mismatch for MSVC plperl vs gcc built perl libs commit : 68d89d80c3db06ad080a0f291e165456fb2f51f7 author : Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 Click here for diff When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 0000000012800080, needed 0000000012900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl.

PostgreSQL 14.0 (upcoming) commit log

Fix binary mismatch for MSVC plperl vs gcc built perl libs commit : f3f70b8de66c0bae86f4761e152c10dd39f6f179 author : Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Sun, 27 Nov 2022 09:03:22 -0500 Click here for diff When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 0000000012800080, needed 0000000012900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl.

pgBackRest 2.44 (upcoming) commit log

Add hint when an option is specified without an index. commit : 3f363cb3aed1a7c6836ee6c32eae600129a6f6b8 author : David Steele <david@pgmasters.net> date : Tue, 22 Nov 2022 15:04:13 +0800 committer: GitHub <noreply@github.com> date : Tue, 22 Nov 2022 15:04:13 +0800 Click here for diff Hopefully this will make it a little clearer to the user what is wrong when they specify an indexed option without an index. Also fix an ambiguous use of cfgParseOptionP().

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

pgBackRest 2.41 commit log

v2.40: OpenSSL 3 Support commit : 1ff531090b9d1eccd9107592398148a51486c9f8 author : David Steele <david@pgmasters.net> date : Mon, 18 Jul 2022 09:32:30 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 18 Jul 2022 09:32:30 -0400 Click here for diff NOTE TO PACKAGERS: An experimental meson build has been added but packagers should continue to use the autoconf/make build for the foreseeable future. Improvements: * OpenSSL 3 support. (Reviewed by Stephen Frost.) * Create snapshot when listing contents of a path.

pgAudit 1.2.6 (upcoming) commit log

Add caveat about auditing the superuser. commit : fff8fbd865d1078635431014ac6928a19f4798ef author : David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:37:06 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 14 Jun 2022 13:37:06 -0400 Click here for diff M README.md Documentation updates for PostgreSQL 15 release. commit : 19325da1df469d8e08eb39a320a108a58b337a0e author : David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:33:53 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:33:53 -0400 Click here for diff

pgAudit 1.3.6 (upcoming) commit log

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 M README.md Documentation updates for PostgreSQL 15 release. commit : c65096b9db2d000696d128018612b5d08f99305c author : David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:33:31 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:33:31 -0400 Click here for diff

pgAudit 1.4.5 (upcoming) commit log

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 M README.md PostgreSQL 15 support. commit : ee1c3f5d042ff9a031ca515305b3ede8526b28b3 author : David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 Click here for diff

pgAudit 1.5.4 (upcoming) commit log

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 M README.md PostgreSQL 15 support. commit : ee1c3f5d042ff9a031ca515305b3ede8526b28b3 author : David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 Click here for diff

pgAudit 1.6.4 (upcoming) commit log

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 M README.md PostgreSQL 15 support. commit : ee1c3f5d042ff9a031ca515305b3ede8526b28b3 author : David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 13 Jun 2022 16:31:20 -0400 Click here for diff

pgBackRest 2.40 commit log

v2.39: Verify and File Bundling commit : 901e829f6dd05fdc15d899bc7f1108883002b1d5 author : David Steele <david@pgmasters.net> date : Mon, 16 May 2022 08:46:24 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 16 May 2022 08:46:24 -0400 Click here for diff Bug Fixes: * Fix error thrown from FINALLY() causing an infinite loop. (Reviewed by Stephen Frost.) * Error on all lock failures except another process holding the lock. (Reviewed by Reid Thompson, Geir RĂ¥ness.

PostgreSQL 10.21 commit log

Stamp 10.21. commit : 6979736b4bcdc57e4699eadcca44b699fd1afd29 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:21:58 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:21:58 -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 : db034c2e2e45216439c14e2b7bb99260914d610f author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.16 commit log

Stamp 11.16. commit : 6ac9161f69829fe327e393bff83d5f390105a70f author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:20:11 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:20:11 -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 : b5576e1b701c8d690ed1ea8d3c17d5df49de3d7c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.11 commit log

Stamp 12.11. commit : f4206b3e5f816bcc45511411bb208d21a68a7e6a author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:18:31 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:18:31 -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 : b4516b1aea7ac98bc21b47a66ad384f50c2bd2b7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 Click here for diff