Life with Open Source

pgBackRest 2.21 (upcoming) commit log

Storage hardlink and symlink features require path feature. commit : d3f717c89208ef132e75b634ad2e91efbda25a04 author : David Steele <david@pgmasters.net> date : Sat, 7 Dec 2019 09:26:51 -0500 committer: David Steele <david@pgmasters.net> date : Sat, 7 Dec 2019 09:26:51 -0500 Click here for diff Since there is only one driver that supports (or is likely to support) links (Posix), require the path feature to make logic in the code simpler. The checks are added just in case another driver supports links.

PostgreSQL 13.0 (upcoming) commit log

Remove PQsslpassword function commit : e75b1e33710249d1699850920c0390fb08ea5673 author : Andrew Dunstan <andrew@dunslane.net> date : Sat, 7 Dec 2019 09:20:53 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Sat, 7 Dec 2019 09:20:53 -0500 Click here for diff This partially reverts commit 4dc6355210. The information returned by the function can be obtained by calling PQconninfo(), so the function is redundant. M doc/src/sgml/libpq.sgml M src/interfaces/libpq/exports.txt M src/interfaces/libpq/fe-connect.c M src/interfaces/libpq/libpq-fe.h Improve test coverage of ruleutils.

PostgreSQL 11.7 (upcoming) commit log

Fix handling of OpenSSL's SSL_clear_options commit : 7ad544fd8e4528e920f994098a587c7ffd8ea595 author : Michael Paquier <michael@paquier.xyz> date : Fri, 6 Dec 2019 15:14:31 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Fri, 6 Dec 2019 15:14:31 +0900 Click here for diff This function is supported down to OpenSSL 0.9.8, which is the oldest version supported since 593d4e4 (from Postgres 10 onwards), and is used since e3bdb2d (from 11 onwards). It is defined as a macro from OpenSSL 0.

PostgreSQL 12.2 (upcoming) commit log

Fix handling of OpenSSL's SSL_clear_options commit : 902276ff1309ce30522d2b1bc343898c786ca02d author : Michael Paquier <michael@paquier.xyz> date : Fri, 6 Dec 2019 15:14:26 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Fri, 6 Dec 2019 15:14:26 +0900 Click here for diff This function is supported down to OpenSSL 0.9.8, which is the oldest version supported since 593d4e4 (from Postgres 10 onwards), and is used since e3bdb2d (from 11 onwards). It is defined as a macro from OpenSSL 0.

PostgreSQL 10.12 (upcoming) commit log

Ensure maxlen is at leat 1 in dict_int commit : 46ce37b67a5144458adb0789eb4e9169a61881fd author : Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 committer: Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 Click here for diff The dict_int text search dictionary template accepts maxlen parameter, which is then used to cap the length of input strings. The value was not properly checked, and the code simply does txt[d->maxlen] = '\0'; to insert a terminator, leading to segfaults with negative values.

PostgreSQL 9.4.26 (upcoming) commit log

Ensure maxlen is at leat 1 in dict_int commit : 44381b1aff0e92acc91381c40f1b07514e93a18b author : Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 committer: Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 Click here for diff The dict_int text search dictionary template accepts maxlen parameter, which is then used to cap the length of input strings. The value was not properly checked, and the code simply does txt[d->maxlen] = '\0'; to insert a terminator, leading to segfaults with negative values.

PostgreSQL 9.5.21 (upcoming) commit log

Ensure maxlen is at leat 1 in dict_int commit : a2fdeb7863a684b661b0fcbaf90f00595be11bd0 author : Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 committer: Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 Click here for diff The dict_int text search dictionary template accepts maxlen parameter, which is then used to cap the length of input strings. The value was not properly checked, and the code simply does txt[d->maxlen] = '\0'; to insert a terminator, leading to segfaults with negative values.

PostgreSQL 9.6.17 (upcoming) commit log

Ensure maxlen is at leat 1 in dict_int commit : fabdad822287d6aac6a80fc57a97d38bd7456958 author : Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 committer: Tomas Vondra <tomas.vondra@postgresql.org> date : Tue, 3 Dec 2019 16:55:51 +0100 Click here for diff The dict_int text search dictionary template accepts maxlen parameter, which is then used to cap the length of input strings. The value was not properly checked, and the code simply does txt[d->maxlen] = '\0'; to insert a terminator, leading to segfaults with negative values.

systemd and rc.local

How to correctly setup rc.local with systemd I have seen many blogs claiming how to setup rc.local support with system but most of those are talking about setting a new service where as systemd comes with legacy rc.local support. systemctl status rc-local Note: you do not have to enable this service, rc-local is automatically executed after network.target using systemd-rc-local-generator. Create rc.local script sudo vi /etc/rc.d/rc.local Add following text #!/bin/bash touch /tmp/rc.

pgBackRest 2.20 commit log

v2.19: C Migrations and Bug Fixes commit : 2d10293d041cbbc72e4a2bac32401f6f384ecb1a author : David Steele <david@pgmasters.net> date : Tue, 12 Nov 2019 15:51:28 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Nov 2019 15:51:28 -0500 Click here for diff Bug Fixes: * Fix remote timeout in delta restore. When performing a delta restore on a largely unchanged cluster the remote could timeout if no files were fetched from the repository within protocol-timeout.

PostgreSQL 9.4.25 commit log

Stamp 9.4.25. commit : 6cd154923526141ee65548513324fa66c72e83d4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:13:41 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:13:41 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 84aad60b9cdade0a9d55f938bec92d788e2c54e9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.5.20 commit log

Stamp 9.5.20. commit : 2b634067fcd0c3ac6d528b261b4c77d97e6aeae2 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:11:27 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:11:27 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 18831346d4e607d35ff338c6e9eec0319cff8d72 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 9.6.16 commit log

Stamp 9.6.16. commit : 39b3a8c830097af84f655a36879eb1b686fb4cd7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:09:28 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:09:28 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 750d72fde6233b4ccad5f5416b68042169c97b61 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:55 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 10.11 commit log

Stamp 10.11. commit : 004ae0a9766236d5d1769301089a014c5ef09cae author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:07:14 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:07:14 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : b75667d84fb3f96418dcef4e464ad0dab97237b6 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 11.6 commit log

Stamp 11.6. commit : 34f805c8cf1bc4d54075526d3b023d9194ccd2cd author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:05:05 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:05:05 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : b3c762a45a14e119acf371f60eb01c8d3607f714 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.

PostgreSQL 12.1 commit log

Stamp 12.1. commit : 578a551f82f7ad746b36d98c401bdc92c136d664 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:03:10 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 17:03:10 -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 Doc: fix ancient mistake, or at least obsolete info, in rules example. commit : 02f7b7ab75680440695a1e205cbb6636551b6013 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 11 Nov 2019 14:39:54 -0500 committer: Tom Lane <tgl@sss.

QNAP UPS Sharing via network

Using QNAP Master UPS on CentOS 7 as Slave On QNAP ssh to your QNAP vi /mnt/HDA_ROOT/.config/ups/upsd.users` Add following towards the end of file. [monuser] password = monpass allowfrom = 192.168.101.101 upsmon slave Goto QNAP Web interface http://<IP Address | domain name > Navigate to : Control Panel / Externaql Devices / UPS [x] Enable network UPS master On CentOS 7 sudo yum install nut-client Edit upsmon.conf vi /etc/ups/upsmon.conf Add following line

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.

PostgreSQL 12.0 commit log

Stamp 12.0. commit : ad1f2885b8c82e0c2d56d7974f012cbecce17a17 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 30 Sep 2019 16:03:42 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 30 Sep 2019 16:03:42 -0400 Click here for diff M configure M configure.in M src/include/pg_config.h.win32 Suppress another CR in program output commit : b60f9afcf4bfe6b1ff73b49b9bab20dde356c7f4 author : Andrew Dunstan <andrew@dunslane.net> date : Mon, 30 Sep 2019 15:48:54 -0400 committer: Andrew Dunstan <andrew@dunslane.net> date : Mon, 30 Sep 2019 15:48:54 -0400 Click here for diff

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.