The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer...
Today version 1.4.0 of Barman has been officially released. The most important feature is incremental backup support, which relies on rsync and hard links and helps you reduce both backup...
PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving...
Japan has been an early and vigorous adopter of PostgreSQL ( back in 2006, when PostgreSQL was still emerging from obscurity in the western hemisphere, I noted that in Tokyo...
For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become...
Written by Francesco Canovai In the previous instalment, we introduced the logical replication feature which has been added to PostgreSQL 9.4. Let’s go on exploring the multitude of new features...
In last couple of months I’ve been working on online upgrade for very large databases as part of the AXLE project and I would like to share my thoughts on...
Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s being changed by some unknown backend at some unknown time. Or a function...
November 7th 2014 was the eighth Italian PostgreSQL Day, the national event dedicated to the promotion of the world’s most advanced open source database. The Italian edition is one of...
Version 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of...
