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 (more…)
The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in this latest version.
A very interesting feature of version 9.5 is the ability to import a schema from a remote database, using Foreign Data Wrapper and the IMPORT FOREIGN SCHEMA command.
We have a remote datasource, served by a gpfdist server. We need to import the data in a Greenplum database, while performing some ETL manipulation during the import.
It is possible to accomplish this goal with a simple transformation in a few steps using Kettle.
In the first part of this tutorial, we have set up all the connections required for creating the job, now we can proceed with data import.Let's drag and drop inside the visual editor an object named tMap. You can find it on the left, in the instruments palette, inside the "elaboration" folder.
hen working with databases, one of the most common task is to load data from one or more CSV files.Several tools are available to achieve this task. Some are executed via command line, like COPY (using psql), some are more complex, like ETL systems.We will start today with Talend but, in the next weeks, we will proceed with Kettle (Pentaho Data Integration).