PostgreSQL 9.6 is now out and so is an updated version of pglogical that works with it.
For quick guide on how to upgrade the database with pglogical you can check my post which announced 9.6beta support.
The main change besides the support for 9.6.x release of PostgreSQL is in the way we handle the output plugin and apply plugin. They have now been merged into single code base and single package so that there is no need to track the pglogical_output separately for the users and developers alike.
We fixed several bugs this time and also made upgrades from 9.4 much easier.
Here is a more detailed list of changes:
keepalive is tuned to much smaller values by default so that pglogical will notice network issues earlier
better compatibility when upgrading from PostgreSQL 9.4
The PostgreSQL 9.6 Release
It feels like only just a few months ago that we were celebrating the release of PostgreSQL 9.5.0, but already we’re very close to the 9.6.0 release! For me personally, I’m very excited about this particular release of PostgreSQL. It was just 5 or 6 months ago that I was busy refectoring
The new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let's look into the changes in more detail.
After months of efforts, I'm pleased that Postgres-XL 9.5r1 is seeing the daylight. It has been tremendous collective efforts by many, both inside and outside 2ndQuadrant. Often it's not visible via commit history or mailing list communications, but I must admit that many folks have contributed in making this grand release. Contributors who wrote code and sent ideas, those who reviewed the code, QA team for testing and enhancing regression coverage, those who did benchmarks to show how we are doing, those who wrote automation to deploy the product and of course the user community for testing the product and providing invaluable feedback. So thank you folks!
Over the year, I've periodically wrote about various enhancements we made to the product. But let me summarise some of them here
The Postgres-XL 9.5R1Beta2 release went out yesterday. It's another step forward to have a stable 9.5 release sometime very soon. A few key enhancements from the last beta release are captured in this blog. For the full list, I would recommend to read the release notes.
Support for binary data transfer for JDBC and libpq
If you'd trouble receiving data in binary format via JDBC or libpq, this release should fix those issues for you. The coordinator now have intelligence to figure out if the client is requesting data in binary format and handle those cases correctly.
Pushdown of Append and MergeAppend plans
One of the problems reported with the beta1 release was that for inherited tables, coordinator fails to pushdown plans to the remote nodes even when its possible. A simple example
The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from SQL into the current development builds. Now no configuration file changes are required to add nodes and there's no need to restart the existing or newly joining nodes.
This change does not appear in the current 0.8.0 stable release; it'll land in 0.9.0 when that's released, and can be found in the bdr-plugin/next branch in the mean time.
New nodes negotiate with the existing nodes for permission to join. Soon they'll be able to the group without disrupting any DDL locking, global sequence voting, etc.
There's also an easy node removal process so you don't need to modify internal catalog tables and manually remove slots to drop a node anymore.
New node join process
Version 1.1.2 of Barman, backup and recovery manager for PostgreSQL, has been officially released and is publicly available for download.
This minor release includes:
Support for the "configuration_files_directory" option that allows to include multiple server configuration files from a directory
Support for special backup IDs: latest, last, oldest, first
Management of multiple servers to the 'list-backup' command: 'barman list-backup all' now list backups for all the configured servers.
Support for "application_name" management for PostgreSQL >= 9.0
Fix of bug #18: ignore missing WAL files if not found during delete
Download and general information
You can find more information on Barman at www.pgbarman.org.
RPMs for RHEL/CentOS 5 (dependencies
Version 1.1.0 is the second release of Barman. Debian/Ubuntu packages are now available as well.