Oracle High Availability concepts in PostgreSQL

Sometimes people ask about certain Oracle High Availability features and whether they exist in PostgreSQL. In most cases, very similar features exist. The reason for the similarity is that PostgreSQL...
October 26, 2017

PG Phriday: Getting RAD with Docker [Part 1]

Fans of Rapid Application Development (RAD!) are probably already familiar with Docker, but what does that have to do with Postgres? Database-driven applications are a dime a dozen these days...
October 20, 2017

pglogical with OmniDB

1. Introduction pglogical is an extension that provides an advanced logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication. Here...
October 19, 2017

Postgres-XL with OmniDB

1. Introduction Postgres-XL (or just XL, for short) is an open source project from 2ndQuadrant. It is a massively parallel database built on top of PostgreSQL, and it is designed...
October 17, 2017

Why PostgreSQL is better than MySQL

Someone recently tweeted about the fantastic news that MySQL fixed a bug. Now in my world, bugs get fixed quickly and well. Bugs happen and they need to be fixed...
October 11, 2017

PG10 at the London PostgreSQL Meetup

We recently hosted the London PostgreSQL Meetup at a new location in Covent Garden. Room was great and its about 100m from Leicester Square tube, so very centrally located and...
October 06, 2017

v10, The Best PostgreSQL Yet?

The short answer … Hell Yeah! The long answer lies in extensive improvements and the impressive new feature list that makes up this major release – which, by the way...
October 05, 2017

PostgreSQL 10 easy installation with 2UDA

PostgreSQL 10 offers an exciting new set of features in addition to making further improvements to many of the already existing features including Big Data, Replication and Scaling, Administration, SQL...
October 03, 2017

Postgres-BDR with OmniDB

1. Introduction Postgres-BDR (or just BDR, for short) is an open source project from 2ndQuadrant that provides multi-master features for PostgreSQL. Here we will show how to build a test...
September 28, 2017