My top #1 open source tool that I have discovered in the last year is definitely Vagrant. Vagrant is a software that helps you build and configure virtual environments for development and testing purposes. Vagrant relies on virtual machine providers such as VirtualBox, VMWare and AWS, as well as provisioning tools such as Chef and […]
The traditional Monash University Prato Centre, historical venue of the first European PGDay, will host the first edition of another conference: Open Source Software for Business, aka OSS4B. OSS4B 2013 will take place in Prato, Tuscany, Italy on September 19 and 20. Through the experience gained with several organisations of PostgreSQL related events, we have […]
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.