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.
Add Barman Official PPA in Ubuntu 12.04 (Precise Pangolin)
Install the latest version of Barman
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.
5th edition of the European conference of PostgreSQL
, now called PGConf.eu.
The "baby" once called PGDay has now grown into a 4 day conference with training, talks and social events.
I have just returned from the breath-taking Prague for the
2ndQuadrant announces the release of Barman 1.1.1.
This minor version fixes a small bug with the "barman recover" command, introduced with version 1.1.0.
Barman users are encouraged to update their systems to this version, which can be
Version 1.1.0 is the second release of Barman. Debian/Ubuntu packages are now available as well.
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
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. :)
will be held in Prato, at the Monash University Centre, on November 23.
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 "
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.
When Damien Clochard from the French/European Community of PostgreSQL posted this
-- this returns a different result each time it is ran
with recursive s as (
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 behaviour.
An interesting query has been twitted by Will Leinweber from
We have submitted a patch for 9.3
, but currently it is still missing a reviewer.
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.
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