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 […]
Call for papers for PGDay.IT has been extended
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThe 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 “International call for papers” section of the website. In the submission, we suggest international speakers to specify their travel expenses – as organisers we will […]
The “French Revolution”
/3 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniWhen 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 of PostgreSQL in Europe by the community finally received a first important recognition among the public sector.
CTE and the Birthday Paradox
/0 Comments/in Gianni's PlanetPostgreSQL, PostgreSQL /by Gianni CiolliAn 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() union select random() from s ) select count(*) from s; I like this example: a surprising result, which can be explained by (and indeed helps to explain) CTE […]
PostgreSQL 9.3 development: Array ELEMENT Foreign Keys
/19 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniAs 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 the development of the next release: PostgreSQL 9.3. The Italian team of 2ndQuadrant has been working since last year on adding a new feature to […]
Managing useful clusters with repmgr
/9 Comments/in Jaime's PlanetPostgreSQL /by Jaime CasanovaTo 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 […]
Submit your talk for PGDay.IT
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThe 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.
Management of the WAL archive in Barman
/4 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniBarman, 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 […]
How to test Greenplum Community Edition 4.2.1 on VirtualBox
/2 Comments/in Greenplum /by Marco NenciariniAs 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.
Barman is finally out
/3 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniIt 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 […]
Greenplum CE 4.2 XML support
/0 Comments/in Greenplum /by Carlo AscaniIn this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support.