Sunday, April 22

Barman 1.1.1 packages available for Ubuntu 12.04 (Precise Pangolin)

Barman 1.1.1 was released few days ago, but until now it wasn’t available for Ubuntu 12.04. Now, you can simply add the below PPA to get the latest version of Barman in your Ubuntu 12.04 LTS. This quick tutorial will show you how to add Barman Official PPA in Ubuntu 12.04. Objectives: Add Barman Official PPA in Ubuntu 12.04 (Precise Pangolin) Install the latest version of Barman Enjoy! To get started, run the commands below to add the PPA (Personal Package Archive) to your software sources. If you miss the add-apt-repository command please install the python-software-properties package Next, run the commands below to update your package indexes. Finally, run the commands below to install Barman. Barman is installed in your system. To (more…)

Barman explained in a 83 seconds spot

Gabriele's PlanetPostgreSQL
On the dawn of the release of version 1.1.0 of Barman, we are proud to publish our first video/spot for the promotion of our open source tool. The goal of the video is to emphasize the importance of physical hot backups and disaster recovery solutions for PostgreSQL databases operating in business critical environments. One of the most important news for version 1.1.0 is the availability of Debian and Ubuntu packages (Barman will be officially shipped with Ubuntu 12.10), thanks to our Debian Developer Marco Nenciarini. Even though version 1.0 came out last July, Barman will be officially presented next Monday, October 15 in Prato (Italy), during the first workshop on disaster recovery of PostgreSQL databases with it. Enjoy this video (more…)

Call for papers for PGDay.IT has been extended

Gabriele's PlanetPostgreSQL
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 "International call for papers" section of the website. In the submission, we suggest international speakers to specify their travel expenses - as organisers we will evaluate them according to the budget. Important: you are not required to present your talk in Italian. :) Italian PGDay will be held in Prato, at the Monash University Centre, on November 23.

PostgreSQL 9.3 development: Array ELEMENT Foreign Keys

Gabriele's PlanetPostgreSQL
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 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 PostgreSQL: support of referential integrity between the elements of an array in a table (referencing) and the records of another table (referenced). We renamed it "Array ELEMENT foreign keys" - thanks to the feedback received from the hackers list. As you may have guessed, it is not part of the SQL standard. We have submitted a patch for 9.3, but currently it is still missing a reviewer. (more…)

Managing useful clusters with repmgr

Jaime's PlanetPostgreSQL
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 an important part of maintaining a healthy PostgreSQL environment. Repmgr 2.0 gives you the opportunity to configure a more streamlined failover process for when you need it. Repmgr 2.0 was released as a beta about a month ago, and we incorporated many feature requests received from the community. If you requested something of the tool which didn’t make it into this release, keep on us, as we’ve been working hard to insure we a had release out prior to 9.2 (more…)