Management of the WAL archive in Barman

Barman, backup and recovery manager for PostgreSQL, is designed to manage the archive of WAL files separately from periodical backups (in Postgres terms, base backups). You can see this archive...
August 22, 2012

Barman is finally out

It took longer than expected, but we have finally managed to release Barman as open-source under GNU GPL 3. Barman stands for “ Backup and Recovery Manager” and it is...
July 24, 2012

Mapreduce in Greenplum 4.1 - 2nd part

Through this article, we are going to complete the MapReduce job started in the [previous article](https://www.2ndquadrant.com/en/2011/10/mapreduce-in-greenplum.html). ## Take up the problem from the previous article In the [previous article](https://www.2ndquadrant.com/en/2011/10/mapreduce-in-greenplum.html), we...
November 17, 2011

Mapreduce in Greenplum 4.1

Mapreduce is a very trendy software framework. It has been introduced by Google (TM) in 2004. It is a large topic, and it is not possible to cover all of...
October 31, 2011

Using gpmigrator in Greenplum 4.1.1

In this article, I am going to upgrade a Greenplum cluster from version 4.0 to 4.1 using `gpmigrator`. `gpmigrator` is an utility shipped with Greenplum Community Edition whose purpose is...
October 17, 2011

Using dblink in Greenplum

I’m going to demonstrate how it is possible to use dblink in Greenplum 4.0.4.0 What’s dblink? —————— dblink is a PostgreSQL contrib module that allows to execute queries on another...
September 28, 2011

Using PL/Java in Greenplum

In this article we are going to show you how to write PL/Java functions in Greenplum. I assume that you have a working Greenplum (or Greenplum Community Edition) at your...
September 16, 2011

Association rules with MADlib in Greenplum

[*MADlib*](http://madlib.net) is an open-source library for scalable in-database analytics which targets the PostgreSQL and the Greenplum databases. MADlib version 0.2beta needs to be installed properly to follow this article, so...
September 09, 2011

The cost of free PostgreSQL publicity

The software license PostgreSQL is released under makes it extremely friendly to businesses who would like to use the database in commercial products. Partly as a result of this, a...
June 27, 2011