Version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to receive WAL files via streaming replication protocol, as an additional channel ( not yet an exclusive one – we are working on it). This feature reduces the risk of data loss (RPO), through the transparent integration of pg_receivexlog in Barman. A thorough refactoring activity and more...

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data, allowing PostgreSQL to be competitive in managing the “lingua franca” of the moment for the exchange of data via web services. It is useful to perform a number of tests to verify its actual performance. Test data We will run our tests using the customer reviews data from Amazon for the year...

Barman 1.1.1 was released few days ago, but until now it wasn’t available for Ubuntu 12.04. Now, you can simply add the below PPA to get the latest version of Barman in your Ubuntu 12.04 LTS. This quick tutorial will show you how to add Barman Official PPA in Ubuntu 12.04. Objectives: Add Barman Official PPA in Ubuntu 12.04 (Precise Pangolin) Install the latest version of Barman Enjoy! To get...

As usual Greenplum Community Edition 4.2.1 is available as a VMWare virtual machine based on CentOS with all the fancy tools and the documentation already installed. This allows you to easily try it. This article is an updated guide about running the provided image on VirtualBox. Assuming you already have VirtualBox installed (if not you can install it from your package manager or download it from...

Some members of the Greenplum Community Forum have been asking about how to install on Greenplum CE a very useful “contrib” module available for PostgreSQL. We have prepared a slightly modified version of the module that can be easily installed by decompressing the tarball file and executing: make make install fuzzystrmatch-gp-4.0.4.0.tar

Officially Greenplum Database Single Node Edition (SNE) is only installable on Red Hat Enterprise Linux (RHEL) and SUSE Linux Enteprise Server (SLES), but while surfing the web I have seen many requests on how to install it on Debian/Ubuntu. Here I’m trying to give you some advices. Before installing Greenplum Database SNE, you need to adjust the following OS configuration parameters: Set the...