Life with Open Source

pgBackRest 2.33 (upcoming) commit log

Fix return type for PQresultStatus(). commit : 8d883ea76b2e4d48bea3772367ca3e3257434a07 author : David Steele <dsteele@pgmasters.net> date : Thu, 21 Jan 2021 18:30:24 -0500 committer: David Steele <dsteele@pgmasters.net> date : Thu, 21 Jan 2021 18:30:24 -0500 Click here for diff Found on MacOS M1. M src/postgres/client.c Change variant to uint when building option lists. commit : bc25e9bf056b7082a1e69a7a59affb1b61ae6f51 author : David Steele <dsteele@pgmasters.net> date : Thu, 21 Jan 2021 17:36:33 -0500 committer: David Steele <dsteele@pgmasters.

PostgreSQL 12.6 (upcoming) commit log

Fix pull_varnos' miscomputation of relids set for a PlaceHolderVar. commit : 1cce024fd26be40412c41e9ec59f389cf5979da2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 21 Jan 2021 15:37:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 21 Jan 2021 15:37:23 -0500 Click here for diff Previously, pull_varnos() took the relids of a PlaceHolderVar as being equal to the relids in its contents, but that fails to account for the possibility that we have to postpone evaluation of the PHV due to outer joins.

PostgreSQL 13.0 (upcoming) commit log

Fix pull_varnos' miscomputation of relids set for a PlaceHolderVar. commit : 73fc2e5bab1e4bad433d00b2b645cfdd234657db author : Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 21 Jan 2021 15:37:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 21 Jan 2021 15:37:23 -0500 Click here for diff Previously, pull_varnos() took the relids of a PlaceHolderVar as being equal to the relids in its contents, but that fails to account for the possibility that we have to postpone evaluation of the PHV due to outer joins.

PostgreSQL 10.16 (upcoming) commit log

Further tweaking of PG_SYSROOT heuristics for macOS. commit : a3345383d88b7410bee3d73852cfd5c0f5737973 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 Click here for diff It emerges that in some phases of the moon (perhaps to do with directory entry order?), xcrun will report that the SDK path is /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk which is normally a symlink to a version-numbered sibling directory.

PostgreSQL 11.11 (upcoming) commit log

Further tweaking of PG_SYSROOT heuristics for macOS. commit : cbcff1729ff27a7fb28d3339e448f90ca0a70dac author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 Click here for diff It emerges that in some phases of the moon (perhaps to do with directory entry order?), xcrun will report that the SDK path is /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk which is normally a symlink to a version-numbered sibling directory.

PostgreSQL 9.5.25 (upcoming) commit log

Further tweaking of PG_SYSROOT heuristics for macOS. commit : 175f716a8f37c0325cc3f683dad242536f9515d0 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 Click here for diff It emerges that in some phases of the moon (perhaps to do with directory entry order?), xcrun will report that the SDK path is /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk which is normally a symlink to a version-numbered sibling directory.

PostgreSQL 9.6.21 (upcoming) commit log

Further tweaking of PG_SYSROOT heuristics for macOS. commit : cbcf7b130f5e53e405c5b366e78a4b3d8ff5f642 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 20 Jan 2021 12:07:23 -0500 Click here for diff It emerges that in some phases of the moon (perhaps to do with directory entry order?), xcrun will report that the SDK path is /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk which is normally a symlink to a version-numbered sibling directory.

pgAudit 1.1.4 (upcoming) commit log

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 M pgaudit.c Improve compile and install instructions. commit : a93513bf1d5f902cdfe19095f4c246c172d64fdc author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:00:28 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 09:00:28 -0500 Click here for diff

pgAudit 1.2.3 (upcoming) commit log

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 M pgaudit.c Improve compile and install instructions. commit : dda818d55d421a25c1a4655523c9e6a4ddd9414c author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 08:59:35 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 08:59:35 -0500 Click here for diff

pgAudit 1.3.3 (upcoming) commit log

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 M pgaudit.c Improve compile and install instructions. commit : 609b5b5098a4bc33d4f73807b72c7cfe9bd11f58 author : David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 08:58:44 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Jan 2021 08:58:44 -0500 Click here for diff

pgBackRest 2.32 commit log

v2.31: Minor Bug Fixes and Improvements commit : e116b535e6ad21248c00a6d0d948575ed06c6e38 author : David Steele <david@pgmasters.net> date : Mon, 7 Dec 2020 09:55:00 -0500 committer: David Steele <david@pgmasters.net> date : Mon, 7 Dec 2020 09:55:00 -0500 Click here for diff Bug Fixes: * Allow [, #, and space as the first character in database names. (Reviewed by Stefan Fercot, Cynthia Shang. Reported by Jefferson Alexandre.) * Create standby.signal only on PostgreSQL 12 when restore type is standby.

PostgreSQL 9.5.24 commit log

Stamp 9.5.24. commit : f57cc8693b15b79186684f02b729090a149b7555 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:34:09 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:34:09 -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 Last-minute updates for release notes. commit : d43ba1d84ccb74fd394c01ff23b033b26ab154c0 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:14 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.20 commit log

Stamp 9.6.20. commit : e4554425e6d3b429a207ac1a109af9d7e1d14da6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:32:22 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:32:22 -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 Last-minute updates for release notes. commit : 0425151233e018edfc03d2c3fe38f94ef3a67e77 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:14 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 10.15 commit log

Stamp 10.15. commit : e6c792ab72b99a3d68bf0696d0720e9afc61695c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:29:52 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:29:52 -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 Last-minute updates for release notes. commit : b0529799960e910c4cf1e3d5509572dc8c653d67 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 11.10 commit log

Stamp 11.10. commit : 7e0c8283c021abf15f24f217e6bcc7faf4860b34 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:28:11 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:28: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 Last-minute updates for release notes. commit : cb2fffe0d627d3437737ab5293c435b302f6bccf author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 12.5 commit log

Stamp 12.5. commit : 6bb1b38fa5388a4aa39ed9e56ef477f618fb28e1 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:26:33 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 17:26:33 -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 : 0b59df670bd15065a87d1d9c216c3787839937fe author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 Nov 2020 13:02:13 -0500 committer: Tom Lane <tgl@sss.

pgAudit 1.1.3 commit log

Stamp 1.1.3. commit : edab09603f2b9e25d2c3f7799400b1e7208ce40b author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 16:10:58 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 16:10:58 -0400 Click here for diff M Makefile A pgaudit–1.1.2–1.1.3.sql R094 pgaudit–1.1.2.sql pgaudit–1.1.3.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : 766c773e9329c98ebf993ccc3b022cbc6866848a author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:59:23 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.2.2 commit log

Stamp 1.2.2. commit : 8178fc31cf758ccec7c1c9f7c21d1f6f41a4753b author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:57:06 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:57:06 -0400 Click here for diff M Makefile A pgaudit–1.2.1–1.2.2.sql R094 pgaudit–1.2.1.sql pgaudit–1.2.2.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : 33121cd796d4538e1690439f6ec5b6a3e4445d67 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:57:54 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.3.2 commit log

Stamp 1.3.2. commit : 08e259ae81e337d3b2bd2ef837d216b05b3348b7 author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:44:09 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 15:44:09 -0400 Click here for diff M Makefile A pgaudit–1.3.1–1.3.2.sql R094 pgaudit–1.3.1.sql pgaudit–1.3.2.sql M pgaudit.control Add PostgreSQL 12/13 versions and update URLs. commit : cda5efecbd0d8b2824351c0c49d0c44a7dc2ce63 author : David Steele <david@pgmasters.net> date : Wed, 9 Sep 2020 09:57:12 -0400 committer: David Steele <david@pgmasters.

pgBackRest 2.31 commit log

v2.30: PostgreSQL 13 Support commit : 9229d6c866ee6296180bfefdbce42660b9e59b98 author : David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 11:51:45 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Oct 2020 11:51:45 -0400 Click here for diff Bug Fixes: * Error with hints when backup user cannot read pg_settings. (Reviewed by Stefan Fercot, Cynthia Shang. Reported by Mohamed Insaf K.) Features: * PostgreSQL 13 support. (Reviewed by Cynthia Shang.) Improvements: * Improve PostgreSQL version identification.

pgBackRest 2.30 commit log

v2.29: Auto S3 Credentials on AWS commit : 1df7d3eee5baa38504478fafa27de2b1b0fce724 author : David Steele <david@pgmasters.net> date : Mon, 31 Aug 2020 07:28:22 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 31 Aug 2020 07:28:22 -0400 Click here for diff Bug Fixes: * Suppress errors when closing local/remote processes. Since the command has completed it is counterproductive to throw an error but still warn to indicate that something unusual happened. (Reviewed by Cynthia Shang.

PostgreSQL 9.5.23 commit log

Stamp 9.5.23. commit : 641d7cf4bc92499fdbf23f3b47112502d5720599 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:23:10 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:23:10 -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 : 2e0358752da35d9c3496a5b448983d0ebd0ed9d9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.19 commit log

Stamp 9.6.19. commit : 03f5894b35c044f9b261bd00822ae4f009004871 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:21:12 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:21:12 -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 : a7e51a407658c65b3c3458bbbbff6c46a3c182b2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.14 commit log

Stamp 10.14. commit : a293b42e5274bb563fc10910272f30451f0857fb author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:19:16 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:19:16 -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 : d3aa1d4f48a49533cd3ea1dc845aefad89b60065 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.9 commit log

Stamp 11.9. commit : 25180875cb90ef18e83ce45697a9a4d4686b552b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:17:40 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 17:17:40 -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 : 6f57b9bf39283b89808c45da360c748ab29535c6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 10 Aug 2020 15:35:46 -0400 committer: Tom Lane <tgl@sss.