Intel SSDs: Lifetime and the 320 vs. 710 Series
One of the most common questions here is “what’s the cheapest SSD I can put my database on?”, with the implied hope “…without losing it all the time“.
Global trends in deploying PostgreSQL
Talking to people deploying PostgreSQL in several countries during a short span of time has given me some interesting perspective on where the project is at.
Using the PostgreSQL System Columns
There are a few parts of the PostgreSQL internals that poke out usefully if you look in the right place for them.
Limitations removed in PostgreSQL 9.1
“How long should I wait before deploying 9.1?” - I have a very strong opinion on: you should consider 9.1 for new projects instead of 9.0.
Announcing Barman 1.2.1
Version 1.2.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, introducing bandwidth limitation for…
Configuring retention policies in Barman
In our previous article we went through describing what retention policies are and how they can be…
Retention of backups with Barman
Defining a disaster recovery plan involves defining backup policies. A key aspect of backup policies is to…
The first Australian PostgreSQL Day
The first Australian PostgreSQL conference has come to an end and I am extremely happy that I…
Help us make a better PostgreSQL 9.3!
As interest in PostgreSQL grows, so does the rate at which new patches are proposed. To maintain…
Cygwin users needed to test a patch for PostgreSQL 9.3
Cygwin users, If you use PostgreSQL on Cygwin, please try out this build fix, verifying that it…
Testers needed for proposed 9.3 SEPostgreSQL enhancements
SELinux / SEPostgreSQL users: There are some proposed improvements in the 2013-01 commitfest that might go into…
PostgreSQL regression tests hanging on Windows? Check path depth.
I just confirmed the cause an extremely weird problem that’s been frustrating me for days. I want…
It’s a long way to Melbourne if you want to rock ‘n’ roll with Postgres!
That’s right. Melbourne will be hosting the first Australian PostgreSQL Day, on February 4. The momentum continues…
Simplifying compilation of PostgreSQL on Windows
As part of some internal continuous integration and testing work, I’ve put together some scripts to simplify…
Barman 1.1.2 released
Version 1.1.2 of Barman, backup and recovery manager for PostgreSQL, has been officially released and is publicly…
Managing the backup of several PostgreSQL servers with Barman
One of the key aspects of Barman is the possibility to remotely backup multiple PostgreSQL servers from…
79 real attendees at the Italian PGDay
The sixth edition of the Italian PGDay took place in Prato at the Monash University Centre last…
During installation, cluster initialisation fails with the message “No error” on Windows
Today I ran into another strange issue with PostgreSQL installation on Windows. It turned out not to…
Improving PostgreSQL performance on AWS EC2
Questions periodically come up on the PostgreSQL mailing list regarding Amazon EC2 and how to get PostgreSQL…
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,…