Life with Open Source

PostgreSQL 12.0 (upcoming) commit log

Avoid using lcons and list_delete_first where it's easy to do so. commit : d97b714a219959a50f9e7b37ded674f5132f93f3 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 17 Jul 2019 11:15:28 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 17 Jul 2019 11:15:28 -0400 Click here for diff Formerly, lcons was about the same speed as lappend, but with the new List implementation, that's not so; with a long List, data movement imposes an O(N) cost on lcons and list_delete_first, but not lappend.

PostgreSQL 10.10 (upcoming) commit log

Fix thinko in construction of old_conpfeqop list. commit : 583025c3c7e61448d1e6facca770a2171666428c author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 Click here for diff This should lappend the OIDs, not lcons them; the existing code produced a list in reversed order. This is harmless for single-key FKs or FKs where all the key columns are of the same type, which probably explains how it went unnoticed.

PostgreSQL 11.5 (upcoming) commit log

Fix thinko in construction of old_conpfeqop list. commit : 46e2a18d0dfd140bfa36e5d543feeac5f5600244 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 Click here for diff This should lappend the OIDs, not lcons them; the existing code produced a list in reversed order. This is harmless for single-key FKs or FKs where all the key columns are of the same type, which probably explains how it went unnoticed.

PostgreSQL 9.4.24 (upcoming) commit log

Fix thinko in construction of old_conpfeqop list. commit : 67bd6adcb64b182137142f6fd501024a5b971147 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 Click here for diff This should lappend the OIDs, not lcons them; the existing code produced a list in reversed order. This is harmless for single-key FKs or FKs where all the key columns are of the same type, which probably explains how it went unnoticed.

PostgreSQL 9.5.19 (upcoming) commit log

Fix thinko in construction of old_conpfeqop list. commit : f9208f2469635c372bf3c2ccfc9835dc11bd8c1c author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 Click here for diff This should lappend the OIDs, not lcons them; the existing code produced a list in reversed order. This is harmless for single-key FKs or FKs where all the key columns are of the same type, which probably explains how it went unnoticed.

PostgreSQL 9.6.15 (upcoming) commit log

Fix thinko in construction of old_conpfeqop list. commit : a6e7eb42d6112ba1c1a9b678a913a9de66a11ff9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Tue, 16 Jul 2019 18:17:47 -0400 Click here for diff This should lappend the OIDs, not lcons them; the existing code produced a list in reversed order. This is harmless for single-key FKs or FKs where all the key columns are of the same type, which probably explains how it went unnoticed.

pgBackRest 2.17 (upcoming) commit log

Add constants for path and archive.info/backup.info combinations. commit : cdb75ac8b38810e2e7c6f5d0161443650f94bb31 author : Cynthia Shang <cynthia.shang@crunchydata.com> date : Mon, 15 Jul 2019 07:13:36 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 15 Jul 2019 07:13:36 -0400 Click here for diff Contributed by Cynthia Shang. M src/command/archive/get/file.c M src/command/archive/push/push.c M src/command/expire/expire.c M src/info/infoArchive.c M src/info/infoArchive.h M src/info/infoBackup.c M src/info/infoBackup.h Allow NULL in JSON list. commit : ede7df9fb1d937f228e982d987d306345007dfe0 author : David Steele <david@pgmasters.

pgBackRest 2.15 commit log

Begin v2.16 development. commit : 466602387bc279aa44a811dc2948b893e4127b2c author : David Steele <david@pgmasters.net> date : Tue, 25 Jun 2019 08:42:20 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 25 Jun 2019 08:42:20 -0400 Click here for diff M doc/RELEASE.md M doc/resource/git-history.cache M doc/xml/release.xml M lib/pgBackRest/Version.pm M src/configure M src/configure.ac M src/perl/embed.auto.c M src/version.h v2.15: C Implementation of Expire commit : 6650d8144cba46f93ad75c11ad98d87c57d2ea7f author : David Steele <david@pgmasters.net> date : Tue, 25 Jun 2019 08:29:06 -0400 committer: David Steele <david@pgmasters.

PostgreSQL 9.4.23 commit log

Stamp 9.4.23. commit : a01e72fb69cb808364788b5360546f75cf2198df author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:26:08 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:26:08 -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 Translation updates commit : 5eaeea2cecb98161d41e11aff917c91177a8ad0c author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 17 Jun 2019 14:45:16 +0200 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 9.5.18 commit log

Stamp 9.5.18. commit : 683c768cbb7adc18fa0be93e41a090a48b000225 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:23:53 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:23:53 -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 Translation updates commit : 944bf6b4df7d005de130e4d1c3a735788f89e5c3 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 17 Jun 2019 14:46:50 +0200 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 9.6.14 commit log

Stamp 9.6.14. commit : 25cd1175fce691517c9e55311d9a1e4ecf930a32 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:21:22 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:21:22 -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 : 7dc3e28173b6d7527a24bb8a4e324137c7cfe9d2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 10:53:45 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.9 commit log

Stamp 10.9. commit : cb4cb7401e12f5796a5e16fabddeffae3cac39b5 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:18:49 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:18: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 : 8339895d8f797d8d1ccbd555937ed8cc727ea279 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 10:53:45 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.4 commit log

Stamp 11.4. commit : e5f26d79badfae8018ac70f2137158fe36246c2b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:15:30 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 17:15:30 -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 : a4e4418c3f68986607d7b588389e026108c79d71 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 17 Jun 2019 10:53:45 -0400 committer: Tom Lane <tgl@sss.

pgAudit 1.0.8 (upcoming) commit log

Update copyright end year. commit : 14dbf8814e92487184e5923fba87abac4cfde44b author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:56 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:56 -0400 Click here for diff M pgaudit.c

pgAudit 1.1.3 (upcoming) commit log

Update copyright end year. commit : 7f66b9ee8994f7c09d63594b5ef65864415e652e author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:32 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:32 -0400 Click here for diff M pgaudit.c

pgAudit 1.2.2 (upcoming) commit log

Update copyright end year. commit : 96b86ae6fa5095b97d055e1271417c8221a7d1f4 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:11 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:20:11 -0400 Click here for diff M pgaudit.c

pgAudit 1.3.2 (upcoming) commit log

Update copyright end year. commit : 38e59beda8bd207a1f2a8da829f40258f5bb60b3 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:19:56 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 14:19:56 -0400 Click here for diff M pgaudit.c

pgAudit 1.0.7 commit log

Stamp 1.0.7. commit : 847d3bdbaba356a46d1408b2fe9105dd73d52cc7 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:25:52 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:25:52 -0400 Click here for diff M Makefile A pgaudit–1.0.6–1.0.7.sql R094 pgaudit–1.0.6.sql pgaudit–1.0.7.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 4a25265974287f45e987aa4e15bba17de651bef2 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:36:16 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.1.2 commit log

Stamp 1.1.2. commit : 527fa2114bf9fec12593c71e00ed30f314acaf3a author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:15:43 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:15:43 -0400 Click here for diff M Makefile A pgaudit–1.1.1–1.1.2.sql R094 pgaudit–1.1.1.sql pgaudit–1.1.2.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 5caff1395cf9070e70a1e85a7592d7010e4ff1e2 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:34:05 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.2.1 commit log

Stamp 1.2.1. commit : f56258e1cf0642e7df02bbd85535f2fb446bdd9f author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:06:58 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 13:06:58 -0400 Click here for diff M Makefile A pgaudit–1.2–1.2.1.sql R094 pgaudit–1.2.sql pgaudit–1.2.1.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 3a969f4fc1ae7d5e8e17002f43bb5872211ea14f author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:32:14 -0400 committer: David Steele <david@pgmasters.

pgAudit 1.3.1 commit log

Stamp 1.3.1. commit : 4e2e968b364ebb6bb244784c5be39b0abd0bed7a author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:58:41 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:58:41 -0400 Click here for diff M Makefile A pgaudit–1.3–1.3.1.sql R094 pgaudit–1.3.sql pgaudit–1.3.1.sql M pgaudit.control Update Vagrantfile with new box version and PostgreSQL repository. commit : 1487811fe7bcf1f0212dc5462cfaa738feb85412 author : David Steele <david@pgmasters.net> date : Thu, 23 May 2019 12:30:15 -0400 committer: David Steele <david@pgmasters.

pgBackRest 2.14 commit log

v2.14: Bug Fix and Improvements commit : 0f685a33a02adde45792711b957a75391fc5f34e author : David Steele <david@crunchydata.com> date : Mon, 20 May 2019 11:51:58 -0400 committer: David Steele <david@crunchydata.com> date : Mon, 20 May 2019 11:51:58 -0400 Click here for diff Bug Fixes: * Fix segfault when process-max > 8 for archive-push/archive-get. (Reported by Jens Wilke.) Improvements: * Bypass database checks when stanza-delete issued with force. (Contributed by Cynthia Shang. Suggested by hatifnatt.

PostgreSQL 9.4.22 commit log

Stamp 9.4.22. commit : 30b1e1ac4cea9ab32f2912e503589cda09e535aa author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:54:48 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:54:48 -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 : ffe69b4afdae8284ad3f0d4c57640f077799cfa9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.17 commit log

Stamp 9.5.17. commit : b221b78f83f5bc337b596170d70ab0a9d72a2951 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:52:44 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 16:52:44 -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 : 1760514e73e942dcb73231b6d65f6c2ef210c7da author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 6 May 2019 12:45:59 -0400 committer: Tom Lane <tgl@sss.