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...
**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources. ## What is an external table...
JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation. In this short article we’ll see how to use it. ## Download...
With an announce on the forum, Greenplum staff has spoke out about the new version of their Database Management System. I can’t resist to blog about some of its new...
In the [previous article](https://www.2ndquadrant.com/en/2011/12/a-greenplum-41-handbook.html) we have seen how to install Greenplum on multiple nodes. After installation steps, we must init the entire system. Let’s see how. ## Actual situation If...
One of the main advantages using Greenplum is that it gains power when it uses multiple nodes. Horizontal scalability is a main feature of Greenplum. Here is a compact handbook...
The fifth edition of the Italian PGDay went well beyond our initial expectations. We had about 75 participants, a total of 95 people including staff and speakers. As I said...
Greenplum does not officially support Ubuntu Server 11.10 as underlying operating system. However, I needed to install it on the most recent Ubuntu server just to perform some tests and...
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...
Scenario: 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...
