To create a standby in PostgreSQL is relatively easy, and because of the hot standby feature, that alone is certainly very useful. But creating a useful cluster that gives us real HA… that’s another story. The complexities added by failure detection, STONITH rules and choosing a new master could be overwhelming. But still, it is […]
The sixth edition of the Italian PGDay will be held in Prato on November 23 in the historical location of the Monash University Centre. The call for papers has officially been opened today. International speakers are most welcome.
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 […]
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.
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 […]
In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support.
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 […]
**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources.
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.
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 features.