Posts

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 as a “continuous” stream of files from the first available backup to the last shipped file (backup available history for a server). In this article […]

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 an administration tool for disaster recovery of PostgreSQL servers. Currently only Linux systems are officially supported, however Python allows to plan porting and maintenance on different […]

Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL

2ndQuadrant is happy to announce the release of Barman 1.0. Barman (backup and recovery manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python for Linux systems. It allows remote backups of multiple Postgres servers in business critical environments and helps database administrators during the recovery phase. Barman’s most […]

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).

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 its aspetcs in a single blog article. This is a simple introduction to the _mapreduce_ usage in Greenplum 4.1.

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 to perform a live upgrade of an existing database.

Using dblink in Greenplum

I’m going to demonstrate how it is possible to use dblink in Greenplum 4.0.4.0

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 disposal. In this example we will use version **4.0.4**, installed in /usr/local/greenplum-db-4.0.4.0 (which is the default location).

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 we encourage you to read the [official documentation](http://github.com/madlib/madlib/wiki/Installation-Guide-%28v0.2beta%29) to install it in a Greenplum database. I’m going to show you how to perform Association Rules […]

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 significant amount of PostgreSQL development is donated by companies who sell products derived from the database (even entire forks of the source code).  Normally this […]