The new deadline for submitting a paper for the 6th edition of the Italian PGDay is October 7. International speakers are more than welcome to submit their proposal through the...
When Damien Clochard from the French/European Community of PostgreSQL posted this message in the Advocacy list of PostgreSQL, I could not believe my eyes. I felt like years of promotion...
An interesting query has been twitted by Will Leinweber from Postgres Open: -- this returns a different result each time it is ran with recursive s as ( select random()...
As my French colleague Dimitri Fontaine was pointing out a few days ago, PostgreSQL 9.2 is out. This is another great release for PostgreSQL, but we are already ahead in...
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...
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...
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 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...
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...
In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support. Introduction This article has an educational goal. Most likely you will...