I just confirmed the cause an extremely weird problem that’s been frustrating me for days. I want to share it so nobody else has to waste their time on this. It appears that – at least on my build machine, a Windows 7 SP1 x64 box with Windows SDK 7.1, Visual Studio 2010 Express SP1 […]
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, […]
As part of some internal continuous integration and testing work, I’ve put together some scripts to simplify the compilation of PostgreSQL on Windows. PostgreSQL its self is pretty easy to compile on Windows. You download and install ActiveState Perl and Visual Studio or the Microsoft Windows SDK, unpack a PostgreSQL source tree, copy config_default.pl to […]
Version 1.1.2 of Barman, backup and recovery manager for PostgreSQL, has been officially released and is publicly available for download. This minor release includes: Support for the “configuration_files_directory” option that allows to include multiple server configuration files from a directory Support for special backup IDs: latest, last, oldest, first Management of multiple servers to the […]
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 […]
Today I ran into another strange issue with PostgreSQL installation on Windows. It turned out not to be a problem with the installer; instead it was a form of broken Windows installation that I hadn’t seen before, so I thought I’d write it up. The installer already contains checks for several kinds of broken Windows […]
Questions periodically come up on the PostgreSQL mailing list regarding Amazon EC2 and how to get PostgreSQL to perform well on it. The general feeling on the list appears to have been that EC2 performs very poorly for database workloads, at least with PostgreSQL, and it doesn’t seem to be taken particularly seriously as a […]
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 […]
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.