Life with Open Source

PostgreSQL 13.0 (upcoming) commit log

doc: for various substring funcs, document if only first match commit : d629fcf4b36ca8c1e4e9677745ff7d725433ee19 author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:54:35 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:54:35 -0400 Click here for diff Reported-by: troy@frericks.us Discussion: https://postgr.es/m/162614304115.701.2392941350859387646@wrigleys.postgresql.org Backpatch-through: 13 M doc/src/sgml/func.sgml pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : 0a5e708e2bd87adb0779d7c8758e5743cc1c0adf author : Bruce Momjian <bruce@momjian.

PostgreSQL 14.0 (upcoming) commit log

doc: for various substring funcs, document if only first match commit : 6feebcb6b44631c3dc435e971bd80c2dd218a5ab author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:54:35 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:54:35 -0400 Click here for diff Reported-by: troy@frericks.us Discussion: https://postgr.es/m/162614304115.701.2392941350859387646@wrigleys.postgresql.org Backpatch-through: 13 M doc/src/sgml/func.sgml pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : 74cf7d46a91d601e0f8d957a7edbaeeb7df83efc author : Bruce Momjian <bruce@momjian.

PostgreSQL 10.18 (upcoming) commit log

pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : 71121450e8f42b21665ee9c8f70b701f7a16c801 author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 Click here for diff Add pg_resetxlog -u option to set the oldest xid in pg_control. Previously -x set this value be -2 billion less than the -x value. However, this causes the server to immediately scan all relation's relfrozenxid so it can advance pg_control's oldest xid to be inside the autovacuum_freeze_max_age range, which is inefficient and might disrupt diagnostic recovery.

PostgreSQL 11.13 (upcoming) commit log

pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : c4ba87f527f07945ef4ad2b1b45e0afe81124b55 author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 Click here for diff Add pg_resetxlog -u option to set the oldest xid in pg_control. Previously -x set this value be -2 billion less than the -x value. However, this causes the server to immediately scan all relation's relfrozenxid so it can advance pg_control's oldest xid to be inside the autovacuum_freeze_max_age range, which is inefficient and might disrupt diagnostic recovery.

PostgreSQL 12.8 (upcoming) commit log

pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : 7626e9f2be7d0fc9b20936910831b900b555728b author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 Click here for diff Add pg_resetxlog -u option to set the oldest xid in pg_control. Previously -x set this value be -2 billion less than the -x value. However, this causes the server to immediately scan all relation's relfrozenxid so it can advance pg_control's oldest xid to be inside the autovacuum_freeze_max_age range, which is inefficient and might disrupt diagnostic recovery.

PostgreSQL 9.6.23 (upcoming) commit log

pg_resetxlog: add option to set oldest xid & use by pg_upgrade commit : 088dbf3bc40bd866da71e07bef8963c81dbb14b9 author : Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 committer: Bruce Momjian <bruce@momjian.us> date : Mon, 26 Jul 2021 22:38:14 -0400 Click here for diff Add pg_resetxlog -u option to set the oldest xid in pg_control. Previously -x set this value be -2 billion less than the -x value. However, this causes the server to immediately scan all relation's relfrozenxid so it can advance pg_control's oldest xid to be inside the autovacuum_freeze_max_age range, which is inefficient and might disrupt diagnostic recovery.

pgBackRest 2.36 (upcoming) commit log

Automatically generate option value StringIds in make build-config. commit : 52d4574460455975e8929108080dc89bba6cbc7e author : David Steele <david@pgmasters.net> date : Mon, 26 Jul 2021 12:02:31 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 26 Jul 2021 12:02:31 -0400 Click here for diff Remove strIdGenerate() since bldStrId() performs the same function without cluttering the core code. Since bldStrId() is intended to work in non-debug builds, move the validity checks for input strings out of the DEBUG block.

pgAudit 1.4.2 (upcoming) commit log

Add container remove to test command. commit : ed6975c5222de085926221596c98bfb3531f1a97 author : David Steele <david@pgmasters.net> date : Sat, 17 Jul 2021 09:26:28 -0400 committer: David Steele <david@pgmasters.net> date : Sat, 17 Jul 2021 09:26:28 -0400 Click here for diff This allows the test to be run multiple times without leaving behind stopped containers. M test/README.md Update for ProcessUtility_hook_type changes for 14beta2. commit : 70b30d43799edc106f9ebfaee178959043e33081 author : David Steele <david@pgmasters.net> date : Mon, 12 Jul 2021 14:42:50 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.5.1 (upcoming) commit log

Add container remove to test command. commit : ed6975c5222de085926221596c98bfb3531f1a97 author : David Steele <david@pgmasters.net> date : Sat, 17 Jul 2021 09:26:28 -0400 committer: David Steele <david@pgmasters.net> date : Sat, 17 Jul 2021 09:26:28 -0400 Click here for diff This allows the test to be run multiple times without leaving behind stopped containers. M test/README.md Update for ProcessUtility_hook_type changes for 14beta2. commit : 70b30d43799edc106f9ebfaee178959043e33081 author : David Steele <david@pgmasters.net> date : Mon, 12 Jul 2021 14:42:50 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.1.4 (upcoming) commit log

Add .editorconfig. commit : c4c8c9a6f72958b3332fa0e2cae901247587da2a author : David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 committer: David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 Click here for diff A .editorconfig Update copyright end year. commit : 8119f137b2fd70230aa80217726e066e8dba5109 author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:13:34 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:13:34 -0500 Click here for diff

pgAudit 1.2.3 (upcoming) commit log

Add .editorconfig. commit : 0568967d3a36f0d166c7c35ece1d9ca7abd0e6af author : David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 committer: David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 Click here for diff A .editorconfig Update copyright end year. commit : c94c3bed4a2549cefe239756f65cedb8f9bd040f author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:13:12 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:13:12 -0500 Click here for diff

pgAudit 1.3.3 (upcoming) commit log

Add .editorconfig. commit : d6c3a821f6d539aed8a63ac2b28e3b2dec8cd163 author : David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 committer: David Steele <david@pgmasters.net> date : Fri, 11 Jun 2021 11:06:48 -0400 Click here for diff A .editorconfig Update copyright end year. commit : 7b9ca40472c261e5f94bdb9d82446f9f629184cc author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:12:14 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:12:14 -0500 Click here for diff

pgBackRest 2.35 commit log

v2.34: PostgreSQL 14 Support commit : d10a99d73b772f221807024abbf61fdc5ca3a800 author : David Steele <david@pgmasters.net> date : Mon, 7 Jun 2021 06:51:08 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 7 Jun 2021 06:51:08 -0400 Click here for diff Bug Fixes: * Fix issues with leftover spool files from a prior restore. (Reviewed by Cynthia Shang, Stefan Fercot, Floris van Nee. Reported by Floris van Nee.) * Fix issue when checking links for large numbers of tablespaces.

PostgreSQL 9.6.22 commit log

Stamp 9.6.22. commit : 836dda6f1b31c5f7c70ebf52537364ffc3eff577 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:50:15 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:50:15 -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 : cc6c63f8a26d9706bc4b256ac075401bb3d5f759 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:30 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.17 commit log

Stamp 10.17. commit : cffc8fd1ecb09fcd4d8aa98134f4ba8613a01a3a author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:47:56 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:47:56 -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 : 25387cc56d344eaa9545b8233496296cf6087477 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.12 commit log

Stamp 11.12. commit : fae98e3293de89f2fe8fc6e7c196d351378ce80e author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:45:49 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:45:49 -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 : 6c1cfccf226645f4c01b4fee8df2c4e3392f2a32 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.7 commit log

Stamp 12.7. commit : 4bf0bce161097869be5a56706b31388ba15e0113 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:43:52 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 16:43:52 -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 : a9c718bd2d35586da8ebdefa0b72fe7e0d1a725b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 May 2021 13:10:29 -0400 committer: Tom Lane <tgl@sss.

pgBackRest 2.34 commit log

v2.33: Multi-Repository and GCS Support commit : a3d89143d6b34c6019cd29e059d28487037fd109 author : David Steele <david@pgmasters.net> date : Mon, 5 Apr 2021 09:18:20 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Apr 2021 09:18:20 -0400 Click here for diff Bug Fixes: * Fix option warnings breaking async archive-get/archive-push. (Reviewed by Cynthia Shang. Reported by Lev Kokotov.) * Fix memory leak in backup during archive copy. (Reviewed by Cynthia Shang. Reported by Christian ROUX, Efremov Egor.

PostgreSQL 9.5.25 commit log

Stamp 9.5.25. commit : 202c587e2f28bc295f6935d044e20680b627e7a1 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:03:12 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:03:12 -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 : c20a8efa6e2a7374f4cddb76e76213f63b7d7ac5 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:13:24 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:13:24 +0100 Click here for diff

PostgreSQL 9.6.21 commit log

Stamp 9.6.21. commit : 43b434edefdae5607000bb044caec1cf5e0c25c4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:01:30 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 17:01:30 -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 : e641bce57deb2bcbd25f04fe8f56fddaeb7757ea author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:10:23 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:10:23 +0100 Click here for diff

PostgreSQL 10.16 commit log

Stamp 10.16. commit : 5aa3189116ae8f6099b9f1a374978282e38edd43 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:59:29 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:59:29 -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 : 019a3a90bdde362b3b97c6d8b333bd0cccd37711 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:07:32 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:07:32 +0100 Click here for diff

PostgreSQL 11.11 commit log

Stamp 11.11. commit : db5b64b978290e2c2bb0a18edbf2447c1405ccad author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:57:36 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:57:36 -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 : 790567a741cfec6663193084a18890bd05c9e4be author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:00:20 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 18:00:20 +0100 Click here for diff

PostgreSQL 12.6 commit log

Stamp 12.6. commit : 1b9eb7cde7e9cdacd62d206b75ab66bfe6a9a0a4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:56:03 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 8 Feb 2021 16:56:03 -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 : 73844356cfab995b9314f2a66e1de38bc8365f3f author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 17:50:22 +0100 committer: Peter Eisentraut <peter@eisentraut.org> date : Mon, 8 Feb 2021 17:50:22 +0100 Click here for diff

pgBackRest 2.33 commit log

v2.32: Repository Commands commit : aadc9e2fe6ac54783e61c1ff1660feea4d7b1da0 author : David Steele <david@pgmasters.net> date : Mon, 8 Feb 2021 09:08:16 -0500 committer: David Steele <david@pgmasters.net> date : Mon, 8 Feb 2021 09:08:16 -0500 Click here for diff Bug Fixes: * Fix resume after partial delete of backup by prior resume. (Reviewed by Cynthia Shang. Reported by Tom Swartz.) Features: * Add repo-ls command. (Reviewed by Cynthia Shang, Stefan Fercot.) * Add repo-get command.