Life with Open Source

PostgreSQL 13.0 (upcoming) commit log

Split handling of reloptions for partitioned tables commit : 1bbd608fdae7af314d8e2229e369a45a3da83cd8 author : Michael Paquier <michael@paquier.xyz> date : Thu, 14 Nov 2019 12:34:28 +0900 committer: Michael Paquier <michael@paquier.xyz> date : Thu, 14 Nov 2019 12:34:28 +0900 Click here for diff Partitioned tables do not have relation options yet, but, similarly to what's done for views which have their own parsing table, it could make sense to introduce new parameters for some of the existing default ones like fillfactor, autovacuum, etc.

PostgreSQL 12.2 (upcoming) commit log

Add missing check_collation_set call to bpcharne(). commit : 5a6eea0926f4b732a803149a6c169b1f79993fa9 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 15:53:53 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 15:53:53 -0500 Click here for diff We should throw an error for indeterminate collation, but bpcharne() was missing that logic, resulting in a much less user-friendly error (either an assertion failure or "cache lookup failed for collation 0").

PostgreSQL 10.12 (upcoming) commit log

Avoid downcasing/truncation of RADIUS authentication parameters. commit : 4be69e2ea14d4f00c77a1185e68b7f9235aeb95f author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 13:41:04 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 13:41:04 -0500 Click here for diff Commit 6b76f1bb5 changed all the RADIUS auth parameters to be lists rather than single values. But its use of SplitIdentifierString to parse the list format was not very carefully thought through, because that function thinks it's parsing SQL identifiers, which means it will (a) downcase the strings and (b) truncate them to be shorter than NAMEDATALEN.

PostgreSQL 11.7 (upcoming) commit log

Avoid downcasing/truncation of RADIUS authentication parameters. commit : d66e68207e998c9b6180bee5fb55019f35fdacf4 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 13:41:04 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 13:41:04 -0500 Click here for diff Commit 6b76f1bb5 changed all the RADIUS auth parameters to be lists rather than single values. But its use of SplitIdentifierString to parse the list format was not very carefully thought through, because that function thinks it's parsing SQL identifiers, which means it will (a) downcase the strings and (b) truncate them to be shorter than NAMEDATALEN.

PostgreSQL 9.4.26 (upcoming) commit log

Handle arrays and ranges in pg_upgrade's test for non-upgradable types. commit : 56c06999d3c3bb056dd3c6eccd085e7c14bd6a38 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 Click here for diff pg_upgrade needs to check whether certain non-upgradable data types appear anywhere on-disk in the source cluster. It knew that it has to check for these types being contained inside domains and composite types; but it somehow overlooked that they could be contained in arrays and ranges, too.

PostgreSQL 9.5.21 (upcoming) commit log

Handle arrays and ranges in pg_upgrade's test for non-upgradable types. commit : fb26754af4da8bdb25ca3bc8841714c4101c4107 author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 Click here for diff pg_upgrade needs to check whether certain non-upgradable data types appear anywhere on-disk in the source cluster. It knew that it has to check for these types being contained inside domains and composite types; but it somehow overlooked that they could be contained in arrays and ranges, too.

PostgreSQL 9.6.17 (upcoming) commit log

Handle arrays and ranges in pg_upgrade's test for non-upgradable types. commit : f378d4dac4ce80d6772ae4956cd71b10985c481c author : Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Wed, 13 Nov 2019 11:35:37 -0500 Click here for diff pg_upgrade needs to check whether certain non-upgradable data types appear anywhere on-disk in the source cluster. It knew that it has to check for these types being contained inside domains and composite types; but it somehow overlooked that they could be contained in arrays and ranges, too.

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.21 (upcoming) commit log

Modify InfoBackupData struct to use time_t for backup start/stop times. commit : c5b76d213bc24d703e7b973df171a2b01595dabc author : Cynthia Shang <cynthia.shang@crunchydata.com> date : Tue, 12 Nov 2019 17:05:09 -0500 committer: David Steele <david@pgmasters.net> date : Tue, 12 Nov 2019 17:05:09 -0500 Click here for diff The uint64_t types worked but were not consistent with how timestamps are handled in other parts of the code. M src/command/info/info.c M src/info/infoBackup.c M src/info/infoBackup.h

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://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 MONITOR qnapups@192.168.101.253 1 monuser monpass slave Test using upsmon in forground /usr/sbin/upsmon -F Enable service sudo systemctl enable nut-monitor Start service systemctl start nut-monitor

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.