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 during the event, rather than PGDay Italy, this should be named PGDay for Italian speakers given the presence of staff from Switzerland (Canton Ticino). Participants […]
Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL
/0 Comments/in International News, PostgreSQL /by Gabriele Bartolini2ndQuadrant 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 […]
External web tables in Greenplum
/0 Comments/in Greenplum /by Carlo Ascani**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources.
Setting JDBC with Greenplum
/1 Comment/in Greenplum /by Carlo AscaniJDBC 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.
Greenplum 4.2 is out!
/0 Comments/in Greenplum /by Carlo AscaniWith 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 features.
How to initialize Greenplum on multiple nodes
/0 Comments/in Greenplum /by Carlo AscaniIn 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.
A Greenplum 4.1 installation handbook
/0 Comments/in Greenplum /by Carlo AscaniOne 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 to install a multi-node Data Warehouse environment with Greenplum.
PGDay.IT 2011 was “bellissimo”!
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThe 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 during the event, rather than PGDay Italy, this should be named PGDay for Italian speakers given the presence of staff from Switzerland (Canton Ticino). Participants […]
Using Greenplum 4.1 in Ubuntu 11.10
/0 Comments/in Greenplum /by Carlo AscaniGreenplum 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 evaluate it.
Mapreduce in Greenplum 4.1 – 2nd part
/0 Comments/in Greenplum /by Carlo AscaniThrough 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).
Performing ETL using Kettle with GPFDIST and GPLOAD
/1 Comment/in Greenplum /by Giulio CalacociScenario: 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 is possible to accomplish this goal with a simple transformation in a few steps using Kettle.