One of the most recurring questions I get from users that are starting their long and prosperous journey with PostgreSQL involves connecting with the “postgres” user.
In our previous article we went through describing what retention policies are and how they can be enforced on your PostgreSQL server backups with Barman 1.2. In this post, we will go through the configuration aspects.
Defining a disaster recovery plan involves defining backup policies. A key aspect of backup policies is to define how long backup data is retained for disaster recovery purposes. This applies to all digital content, including PostgreSQL databases. Barman 1.2.0 introduces automated management of backup retention policies of PostgreSQL servers.
The first Australian PostgreSQL conference has come to an end and I am extremely happy that I was part of it. The event took place in Melbourne, at the offices of Experian Hitwise in St Kilda Rd. I must confess that, going back to the same building where I had worked in 2005/2006, was a […]
That’s right. Melbourne will be hosting the first Australian PostgreSQL Day, on February 4. The momentum continues as PGDay national events now expand to include the Asia Pacific region. Australia joins the long list of countries which have embraced the Community spirit that is the fundamental principle of the PostgreSQL project: Brasil, China, Argentina, Ecuador, […]
One of the key aspects of Barman is the possibility to remotely backup multiple PostgreSQL servers from one single backup host. The upcoming version 1.1.2 of Barman will make this much easier from a system administrator’s point of view. Let’s see why.
The sixth edition of the Italian PGDay took place in Prato at the Monash University Centre last Friday, November 23rd. As president of the Italian PostgreSQL Users Group (most likely for the last time) and host of Prato, I had the pleasure to open the event and welcome all the attendees – coming from 11 […]
I have just returned from the breath-taking Prague for the 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.
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 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 […]