CHAR (16) – Another conference on the horizon but with a focus on business

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the Postgre ...

More ‘POWER’ for PostgreSQL

Now Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for D ...

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source ...

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual s ...

The Best Barman Ever

This is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me. Version 2.0 takes Barman to a new level, thanks to full ...

Back to the Future Pt. 1: Introduction to pg_rewind

Since PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider ...

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with ...

PostgreSQL vs. Linux kernel versions

I’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), a ...

Evolution of Fault Tolerance in PostgreSQL: Time Travel

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with ...

Speed up getting WAL files from Barman

Starting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel fro ...

Problem with Buildfarm registrations fixed

Recently we switched the PostgreSQL Buildfarm to use https for its front-facing web transactions. That’s worked pretty well, but one thing got broken in the change. The registration page uses a Captcha to help avoid web spam, which has been a problem in the past. However, the code to fetch the relevant html was still…

Processing PostgreSQL JSON & JSONB data in Java

This is part of a series of blogs on Java & PostgreSQL. For links to other blogs in this series, please scroll to the end of this post. Starting v9.2, PostgreSQL is providing native data type support for JSON objects. Subsequent releases introduced JSONB (binary formatted JSON objects) and many data manipulation functions for JSONs,…

Explaining CREATE INDEX CONCURRENTLY

This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it can build a new index on the table, without blocking it from updates/inserts/deletes. But even before that, let’s understand how Heap-Only-Tuple (HOT) works. It was…

Dataloss at GitLab

GitLab, thanks for using PostgreSQL 9.6 and its replication and backup facilities. We’re sorry that you lost your database: https://about.gitlab.com/2017/02/01/gitlab-dot-com-database-incident/ Thank you for posting this publicly to allow us to comment on this for your postmortem analysis. I’m very happy that you monitor Replication Lag, that is good. Replication lag of 4GB is at times…

pgDay 2017 à Paris: conférence PostgreSQL internationale

logo pgDay Paris 2017

Un événement communautaire Cette année encore 2ndQuadrant aide la communauté PostgreSQL en France en étant Partenaire du pgDay 2017 à Paris Cette journée de conférences, en anglais exclusivement, est une opportunité unique d’en apprendre plus sur le fonctionnement et l’activité de PostgreSQL. Sécurité, benchmarks, supervision, roadmap pour la version 10, réplication, … de nombreux sujets,…

Inserting JSONB data in PostgreSQL 9.6

The `jsonb_insert` function brought in with PostgreSQL 9.6 gives more control when inserting new values into a jsonb array and/or new keys into a jsonb object. This article introduces this new function together with some examples.

repmgr 3.3

repmgr 3.3 introduces a number of additional options for setting up and managing replication clusters, with particular emphasis on cascading replication support. These changes will also make it easier to set up complex clusters using provisioning scripts. Additionally there are changes to the repmgr command line utility’s logging behaviour which you should take into consideration…

What does pg_start_backup() do?

Reading mailing lists can damage your health, as I recently discovered on the PostgreSQL Performance list where backup was being discussed. First off, don’t read blogs for finding out critical pieces of info. Read the docs because they are accurate, fully reviewed and well maintained. I should add that I was the initial author of…

The rds_superuser role isn’t that super

The Amazon RDS documentation blithely contains this statement: “When you create a DB instance, the master user system account that you create is assigned to the rds_superuser role. The rds_superuser role is similar to the PostgreSQL superuser role (customarily named postgres in local instances) but with some restrictions.” But just how super is it? One…

Barman 2.1 and the new –archive option

Barman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new…

‹ Prev123456Next ›Last »