Life with Open Source

PostgreSQL 13.0 (upcoming) commit log

Clean up MinGW def file generation commit : ea9e06ac66d3e9584950f52878c8e4b71f963610 author : Peter Eisentraut <peter@eisentraut.org> date : Sun, 20 Oct 2019 10:19:13 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Sun, 20 Oct 2019 10:19:13 +0200 Click here for diff There were some leftovers from ancient ad-hoc ways to build on Windows, prior to the standardization on MSVC and MinGW. We don't need to build a lib$(NAME)ddll.def (debug build, as opposed to lib$(NAME)dll.

PostgreSQL 10.11 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : 083929372e046662957d20b68aacf5e092bb70cb author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

PostgreSQL 11.6 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : af4477b00cf93c8305aebe3b58ea26499664336e author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

PostgreSQL 12.0 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : ef13f914e6c2a66f186f73ec1bba682e56dc621b author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

PostgreSQL 9.4.25 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : 930787c7fab98f14f1e4a98a201a7f7cef2e55bc author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

PostgreSQL 9.5.20 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : 62e881946c4d15f779808991f97ea379263a591d author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

PostgreSQL 9.6.16 (upcoming) commit log

For PowerPC instruction "addi", use constraint "b". commit : 09d74aef33decd311128e65fee2b1abd94f2bc6a author : Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 committer: Noah Misch <noah@leadboat.com> date : Fri, 18 Oct 2019 20:20:28 -0700 Click here for diff Without "b", a variant of the tas() code miscompiles on macOS 10.4. This may also fix a compilation failure involving macOS 10.1. Today's compilers have been allocating acceptable registers with or without this change, but this future-proofs the code by precisely conveying the acceptable registers.

pgBackRest 2.20 (upcoming) commit log

Error when specified vm is invalid. commit : e06db21e35f701b62c625b9f25436459b8fd5c26 author : David Steele <david@pgmasters.net> date : Thu, 17 Oct 2019 14:00:18 +0200 committer: David Steele <david@pgmasters.net> date : Thu, 17 Oct 2019 14:00:18 +0200 Click here for diff M test/lib/pgBackRestTest/Common/VmTest.pm M test/test.pl Disable code generation on dry-run. commit : a52faf83a502427a7079ec2bae0593b318c2594c author : David Steele <david@pgmasters.net> date : Thu, 17 Oct 2019 11:56:45 +0200 committer: David Steele <david@pgmasters.net> date : Thu, 17 Oct 2019 11:56:45 +0200 Click here for diff

pgBackRest 2.19 commit log

v2.18: PostgreSQL 12 Support commit : 4629237d6a308a250cd52fff49693cd0a1069253 author : David Steele <david@pgmasters.net> date : Tue, 1 Oct 2019 16:02:07 -0400 committer: David Steele <david@pgmasters.net> date : Tue, 1 Oct 2019 16:02:07 -0400 Click here for diff Features: * PostgreSQL 12 support. * Add info command set option for detailed text output. The additional details include databases that can be used for selective restore and a list of tablespaces and symlinks with their default destinations.

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:

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.