Life with Open Source

PostgreSQL 15.0 (upcoming) commit log

Fix comment in guc_tables.c commit : bdf9b60085bca2dbb0af920d50f1a0917dda0cbb author : Michael Paquier <michael@paquier.xyz> date : Tue, 4 Oct 2022 15:39:41 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Tue, 4 Oct 2022 15:39:41 +0900 Click here for diff s/ERROR_HANDLING/ERROR_HANDLING_OPTIONS/. Author: Peter Smith Discussion: https://postgr.es/m/CAHut+PtDj3CV+f0pVisc0XYMi2LHGBpQxQWtF0FjiSVN_nV17Q@mail.gmail.com M src/backend/utils/misc/guc_tables.c Cleanup useless assignments and checks commit : c42cd05c586235fa9e84fb4a3682286cf551df0e author : Michael Paquier <michael@paquier.xyz> date : Tue, 4 Oct 2022 13:16:23 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Tue, 4 Oct 2022 13:16:23 +0900 Click here for diff

pgBackRest 2.43 (upcoming) commit log

Fix assert message and add a clarifying comment. commit : f0acc195c0527495857f1afa8b24bdf2a4f477b5 author : David Steele <david@pgmasters.net> date : Mon, 3 Oct 2022 10:02:44 -1000 committer: David Steele <david@pgmasters.net> date : Mon, 3 Oct 2022 10:02:44 -1000 Click here for diff M src/common/io/filter/filter.c Do not log bundle info when a file is delta matched from a prior backup. commit : 6e26860c2648f6e23ad99bb4d38ecb1bfc45dd0c author : David Steele <david@pgmasters.net> date : Sun, 2 Oct 2022 17:48:43 -1000 committer: David Steele <david@pgmasters.

PostgreSQL 12.13 (upcoming) commit log

Avoid improbable PANIC during heap_update, redux. commit : e7bd2d6712495eba037bae0fdbe1bf413110ebe6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 Click here for diff Commit 34f581c39 intended to ensure that RelationGetBufferForTuple would acquire a visibility-map page pin in case the otherBuffer's all-visible bit had become set since we last had lock on that page. But I missed a case: when we're extending the relation, VM concerns were dealt with only in the relatively-less-likely case that we fail to conditionally lock the otherBuffer.

PostgreSQL 13.0 (upcoming) commit log

Avoid improbable PANIC during heap_update, redux. commit : 92941f26435ce3910bb9320fd92bda1e3dd4c6b5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 Click here for diff Commit 34f581c39 intended to ensure that RelationGetBufferForTuple would acquire a visibility-map page pin in case the otherBuffer's all-visible bit had become set since we last had lock on that page. But I missed a case: when we're extending the relation, VM concerns were dealt with only in the relatively-less-likely case that we fail to conditionally lock the otherBuffer.

PostgreSQL 14.0 (upcoming) commit log

Avoid improbable PANIC during heap_update, redux. commit : b93d7e6883d683ea35f4f5ea843222f47aacbaee author : Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Fri, 30 Sep 2022 19:36:46 -0400 Click here for diff Commit 34f581c39 intended to ensure that RelationGetBufferForTuple would acquire a visibility-map page pin in case the otherBuffer's all-visible bit had become set since we last had lock on that page. But I missed a case: when we're extending the relation, VM concerns were dealt with only in the relatively-less-likely case that we fail to conditionally lock the otherBuffer.

PostgreSQL 10.23 (upcoming) commit log

doc: Fix PQsslAttribute docs for compression commit : 8fef56229fb411a239b91f732601912c5bfee6bf author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Fri, 30 Sep 2022 12:03:48 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Fri, 30 Sep 2022 12:03:48 +0200 Click here for diff The compression parameter to PQsslAttribute has never returned the compression method used, it has always returned "on" or "off since it was added in commit 91fa7b4719ac. Backpatch through v10. Reviewed-by: Tom Lane <tgl@sss.

PostgreSQL 11.18 (upcoming) commit log

doc: Fix PQsslAttribute docs for compression commit : f84e2ed246d20c5bd772f1d1c1fba85faf5a144e author : Daniel Gustafsson <dgustafsson@postgresql.org> date : Fri, 30 Sep 2022 12:03:48 +0200 committer: Daniel Gustafsson <dgustafsson@postgresql.org> date : Fri, 30 Sep 2022 12:03:48 +0200 Click here for diff The compression parameter to PQsslAttribute has never returned the compression method used, it has always returned "on" or "off since it was added in commit 91fa7b4719ac. Backpatch through v10. Reviewed-by: Tom Lane <tgl@sss.

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

pgBackRest 2.39 commit log

v2.38: Minor Bug Fixes and Improvements commit : 5249b89a2e94fdbb45461faaf2e1b0304b986ac7 author : David Steele <david@pgmasters.net> date : Sun, 6 Mar 2022 10:30:59 -0600 committer: David Steele <david@pgmasters.net> date : Sun, 6 Mar 2022 10:30:59 -0600 Click here for diff IMPORTANT NOTE: Repository size reported by the info command is now entirely based on what pgBackRest has written to storage. Previously, in certain cases, pgBackRest could detect if additional compression was being applied by the storage but this is no longer supported.

pgAudit 1.2.5 commit log

Stamp 1.2.4. commit : 6d9e5d4ae4b0baf5039845fb71f6e7d52669bbd8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:30:21 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:30:21 -0600 Click here for diff M Makefile A pgaudit–1.2.3–1.2.4.sql R100 pgaudit–1.2.3.sql pgaudit–1.2.4.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 74c4c07899fba3cc7bc791be6b03810786b06762 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 14:16:17 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 14:16:17 -0600 Click here for diff

pgAudit 1.3.5 commit log

Stamp 1.3.4. commit : 6f7799839465a39dc1887e4ad10ef2f67519cd1e author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:25:39 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:25:39 -0600 Click here for diff M Makefile A pgaudit–1.3.3–1.3.4.sql R100 pgaudit–1.3.3.sql pgaudit–1.3.4.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 0a41dfcdb5fcd52d9da1ee0c1c2d174e15934fe8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 13:47:40 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 13:47:40 -0600 Click here for diff

pgAudit 1.4.4 commit log

Stamp 1.4.3. commit : 21fea0792139529302e02af145c90f7ec5cff2eb author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:19:52 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:19:52 -0600 Click here for diff M Makefile A pgaudit–1.4.2–1.4.3.sql R100 pgaudit–1.4.2.sql pgaudit–1.4.3.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 28ab91b8cee30da902d33b3b61a8b62934814370 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 12:37:07 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 12:37:07 -0600 Click here for diff