Life with Open Source

PostgreSQL 12.0 (upcoming) commit log

Add tab completion for CREATE OR REPLACE in psql. commit : fc16778873d081b07930d642622ee0cf22c3f9b7 author : Fujii Masao <fujii@postgresql.org> date : Fri, 13 Sep 2019 18:16:40 +0900 committer: Fujii Masao <fujii@postgresql.org> date : Fri, 13 Sep 2019 18:16:40 +0900 Click here for diff Author: Shenhao Wang Discussion: https://postgr.es/m/63580B24E208E3429D94153A03C68E0901AA8002D5@G08CNEXMBPEKD02.g08.fujitsu.local M src/bin/psql/tab-complete.c Fix nbtree page split rmgr desc routine. commit : 3b6b54f178d7539354064727cca9b4ff2eca0fce author : Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:08 -0700 committer: Peter Geoghegan <pg@bowt.

libvirt - Static IP and local dns

libvirt - Static IP and local dns Setting Static IP for kvm guests When using libvirt (linux kvm), many timnes it is required to assign static ip. One approach is to setup static ip inside guest but just like I use my router’s dhcp server to assign static IPs, I prefer to use same approach for VMs. We can create IP to MAC address bindings in network setup but adding similar line(s) inside dhcp section:

PostgreSQL 11.6 (upcoming) commit log

Fix nbtree page split rmgr desc routine. commit : e87b00b5f650a3c87db67049842f743d534b1cb1 author : Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:05 -0700 committer: Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:05 -0700 Click here for diff Include newitemoff in rmgr desc output for nbtree page split records. In passing, correct an obsolete comment that claimed that newitemoff is only logged for _L variant nbtree page split WAL records.

PostgreSQL 10.11 (upcoming) commit log

Fix nbtree page split rmgr desc routine. commit : 09b236af90befd9e0342040a1503776cee76eccc author : Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:03 -0700 committer: Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:03 -0700 Click here for diff Include newitemoff in rmgr desc output for nbtree page split records. In passing, correct an obsolete comment that claimed that newitemoff is only logged for _L variant nbtree page split WAL records.

PostgreSQL 9.6.16 (upcoming) commit log

Fix nbtree page split rmgr desc routine. commit : 835646503d5d7782d890b7ad5039e64c08e2b89d author : Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:01 -0700 committer: Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:45:01 -0700 Click here for diff Include newitemoff in rmgr desc output for nbtree page split records. In passing, correct an obsolete comment that claimed that newitemoff is only logged for _L variant nbtree page split WAL records.

PostgreSQL 9.5.20 (upcoming) commit log

Fix nbtree page split rmgr desc routine. commit : 9064cc139d10d6e45a370dd8761a02f7e7da36f4 author : Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:44:59 -0700 committer: Peter Geoghegan <pg@bowt.ie> date : Thu, 12 Sep 2019 15:44:59 -0700 Click here for diff Include newitemoff in rmgr desc output for nbtree page split records. In passing, correct an obsolete comment that claimed that newitemoff is only logged for _L variant nbtree page split WAL records.

PostgreSQL 9.4.25 (upcoming) commit log

Fix usage of whole-row variables in WCO and RLS policy expressions. commit : ca08ea52bfbc0e02eb7e866bb05bf166f15c9b75 author : Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 12 Sep 2019 18:29:18 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Thu, 12 Sep 2019 18:29:18 -0400 Click here for diff Since WITH CHECK OPTION was introduced, ExecInitModifyTable has initialized WCO expressions with the wrong plan node as parent -- that is, it passed its input subplan not the ModifyTable node itself.

pgBackRest 2.19 (upcoming) commit log

Sort and find improvements to List and StringList objects. commit : 506c10f7f270806aca8acecaa303bf4458463720 author : David Steele <david@pgmasters.net> date : Thu, 12 Sep 2019 12:04:25 -0400 committer: David Steele <david@pgmasters.net> date : Thu, 12 Sep 2019 12:04:25 -0400 Click here for diff Push the responsibility for sort and find down to the List object by introducing a general comparator function that can be used for both sorting and finding. Update insert and add functions to return the item added rather than the list.

pgBackRest 2.18 commit log

v2.17: C Migrations and Bug Fixes commit : ce2bf2999892f689001b084af4d5feb63dc9b402 author : David Steele <david@pgmasters.net> date : Tue, 3 Sep 2019 16:39:32 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 3 Sep 2019 16:39:32 -0400 Click here for diff Bug Fixes: * Improve slow manifest build for very large quantities of tables/segments. (Reported by Jens Wilke.) * Fix exclusions for special files. (Reported by CluelessTechnologist, Janis Puris, Rachid Broum.) Improvements: * The stanza-create/update/delete commands are implemented entirely in C.

PostgreSQL 9.4.24 commit log

Stamp 9.4.24. commit : 246893dce8ebea90ef083ab801da4d1f474e01ad author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:22:47 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:22:47 -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 : 4908df4a609aa1f2b3def968fe5b94a74cfde214 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.19 commit log

Stamp 9.5.19. commit : 167e5353799eabb034817b1e7bafd674d3c2bb04 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:20:40 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:20: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 : e3d8c9a5f1014be97150d07b3e5af1d32a45df65 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.15 commit log

Stamp 9.6.15. commit : 86ca7f81f7dfc17f04698189dec8973d358bc711 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:18:48 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:18: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 : 3354bd5e2ba921d8267dbd6cac90b491a4f27cae author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 10.10 commit log

Stamp 10.10. commit : 2fbecb66c45eccb8922c371084ae4f0b3a72a86b author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:16:54 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:16:54 -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 : f61bc0048b6b3a9bac7afd469cb6811d29d29d5d author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.5 commit log

Stamp 11.5. commit : fdf16779f107dd22a2cb8430d2eee6c344b34187 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:14:59 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 17:14:59 -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 : d03c0413343ac5a79bc2f6ee5abc84c873efd863 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 5 Aug 2019 11:49:14 -0400 committer: Tom Lane <tgl@sss.

pgBackRest 2.17 commit log

v2.16: C Migrations and Bug Fixes commit : 9e730c1bd61b00fa506ea443cdd6161e88ed31ae author : David Steele <david@pgmasters.net> date : Mon, 5 Aug 2019 12:03:04 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 5 Aug 2019 12:03:04 -0400 Click here for diff Bug Fixes: * Retry S3 RequestTimeTooSkewed errors instead of immediately terminating. (Reported by sean0101n, Tim Garton, Jesper St John, Aleš Zelený.) * Fix incorrect handling of transfer-encoding response to HEAD request.

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