(This article is written with reference to PostgreSQL 9.3. If you’re using a newer version please check to make sure any limitations described remain in place.) PostgreSQL offers several tools...
En noviembre del 2012 asistí al PgDay en Buenos Aires. Ahí presente la charla “Autovacuum, ¿bendición o maldición? Afrontando el reto”. En uno de los puntos de la charla explique...
Version 1.2.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, introducing bandwidth limitation for both backup and recovery operations at three different levels: global, server (PostgreSQL instance)...
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...
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...
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...
As interest in PostgreSQL grows, so does the rate at which new patches are proposed. To maintain the high level of quality in PostgreSQL it is important that all patches...
Cygwin users, If you use PostgreSQL on Cygwin, please try out this build fix, verifying that it works on Cygwin, and that it doesn’t break the Linux/BSD builds or the...
SELinux / SEPostgreSQL users: There are some proposed improvements in the 2013-01 commitfest that might go into PostgreSQL 9.3 – but only if you help. Interested users are needed to...
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...
