Life with Open Source

PostgreSQL 14.0 (upcoming) commit log

Improve SQLSTATE reporting in some replication-related code. commit : 6b787d9e32005867ee3660d1ea20f447810a403d author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 16 Jun 2021 11:52:05 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 16 Jun 2021 11:52:05 -0400 Click here for diff I started out with the goal of reporting ERRCODE_CONNECTION_FAILURE when walrcv_connect() fails, but as I looked around I realized that whoever wrote this code was of the opinion that errcodes are purely optional.

PostgreSQL 12.8 (upcoming) commit log

Fix outdated comment that talked about seek position of WAL file. commit : f98635ad6295ad142779756e60325a8e7f825909 author : Heikki Linnakangas <heikki.linnakangas@iki.fi> date : Wed, 16 Jun 2021 12:34:32 +0300 committer: Heikki Linnakangas <heikki.linnakangas@iki.fi> date : Wed, 16 Jun 2021 12:34:32 +0300 Click here for diff Since commit c24dcd0cfd, we have been using pg_pread() to read the WAL file, which doesn't change the seek position (unless we fall back to the implementation in src/port/pread.

PostgreSQL 13.0 (upcoming) commit log

Fix outdated comment that talked about seek position of WAL file. commit : e89a8e30e0a50e7882ab5a6896a11872bec969e3 author : Heikki Linnakangas <heikki.linnakangas@iki.fi> date : Wed, 16 Jun 2021 12:34:32 +0300 committer: Heikki Linnakangas <heikki.linnakangas@iki.fi> date : Wed, 16 Jun 2021 12:34:32 +0300 Click here for diff Since commit c24dcd0cfd, we have been using pg_pread() to read the WAL file, which doesn't change the seek position (unless we fall back to the implementation in src/port/pread.

PostgreSQL 10.18 (upcoming) commit log

Further refinement of stuck_on_old_timeline recovery test commit : 1dc53c914fe8bace75ed6c227f6c2e6833e3e7b4 author : Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 committer: Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 Click here for diff TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0.

PostgreSQL 11.13 (upcoming) commit log

Further refinement of stuck_on_old_timeline recovery test commit : c0a7587807dd9e0db5dbffb6d6b813a3e87d2519 author : Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 committer: Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 Click here for diff TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0.

PostgreSQL 9.6.23 (upcoming) commit log

Further refinement of stuck_on_old_timeline recovery test commit : e46f6a078c1a4a2293839c9c5560517b2c4e1d12 author : Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 committer: Andrew Dunstan <andrew@dunslane.net> date : Tue, 15 Jun 2021 15:30:11 -0400 Click here for diff TestLib::perl2host can take a file argument as well as a directory argument, so that code becomes substantially simpler. Also add comments on why we're using forward slashes, and why we're setting PERL_BADLANG=0.

pgBackRest 2.36 (upcoming) commit log

Update command/stanza test to use standard patterns. commit : 03021c6a17f1374e84ef42614fa1dd2a6be4b64d author : Cynthia Shang <cynthia.shang@crunchydata.com> date : Mon, 14 Jun 2021 13:28:27 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 14 Jun 2021 13:28:27 -0400 Click here for diff No core code changes; only changes for stanza-create, stanza-upgrade, and stanza-delete command unit tests. M doc/xml/release.xml M test/src/module/command/stanzaTest.c Ignore mismatched close requests in the pq shim during error processing. commit : 80d63a5e8bc6e5e6d6e4d75b349a44f2aac70954 author : 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

pgAudit 1.4.2 (upcoming) commit log

Add .editorconfig. commit : 5b0a3a6c1b436adb46d133c6c4e0a9ff306db094 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 Add pgaudit.log_statement setting. commit : 8831cef691b081ce71a14c10a2980de5c46a88f7 author : Peter Eisentraut <peter@eisentraut.org> date : Thu, 10 Jun 2021 18:27:55 +0200 committer: GitHub <noreply@github.com> date : Thu, 10 Jun 2021 18:27:55 +0200 Click here for diff

pgAudit 1.5.1 (upcoming) commit log

Add .editorconfig. commit : 5b0a3a6c1b436adb46d133c6c4e0a9ff306db094 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 Add pgaudit.log_statement setting. commit : 8831cef691b081ce71a14c10a2980de5c46a88f7 author : Peter Eisentraut <peter@eisentraut.org> date : Thu, 10 Jun 2021 18:27:55 +0200 committer: GitHub <noreply@github.com> date : Thu, 10 Jun 2021 18:27:55 +0200 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.