In Postgres-XL, sequences are maintained at the Global Transaction Manager (GTM) to ensure that they are assigned non-conflicting values when they are incremented from multiple nodes. This adds significant overhead...
PostgreSQL 9.5 adds declarative row security. You can declare policies on tables and have them enforced automatically – for example, allowing user joe to only see rows with the owner...
My colleagues and I are often asked “when will you (2ndQuadrant) contribute BDR to PostgreSQL?” This makes an interesting assumption: that we have not already done so. We have. Much...
2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL. This minor release introduces support for ‘per-server’ concurrency of maintenance operations through...
As you may have noted from my previous blog, the last few months were busy in getting Postgres-XL up-to-date with the latest 9.5 release of PostgreSQL. Once we had a...
Ansible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together! ==================== Prime time announcement ! ==================== PGConf Europe 2015 will be on 27th-30th of...
Version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to return upon request any available WAL file for a given server, allowing...
It’s been busy few months as we work towards merging Postgres-XL with the latest and greatest release of PostgreSQL. Postgres-XL is an open source fork of PostgreSQL that provides a...
PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.6 was announced on the 1st of August 2015. In this blog post we’ll talk about the major new improvements in...
