pglogical announced

Posted on 2016-01-01 by 2ndQuadrant, an EDB Company

2ndQuadrant is pleased to announce the availability of pglogical, the next generation in replication systems for PostgreSQL.

pglogical offers Logical Replication as a PostgreSQL extension, which provides the flexibility of trigger-based replication with the efficiency of log-based replication. This ground-breaking new technology has benefits for many key use cases, including:

  • UPGRADE Upgrade PostgreSQL from 9.4 to 9.5, without downtime
  • SCALE OUT Copy all or a selection of database tables to other nodes in a cluster
  • AGGREGATE Accumulate changes from sharded database servers into a Data Warehouse
  • INTEGRATE Feed database changes in real-time to other systems
  • PROTECT Provide backup or high availability for clusters, replacing earlier technologies

Existing PostgreSQL users will find the efficiency of pglogical particularly exciting with preliminary testing demonstrating a significant increase in transaction throughput (without lag) over other replication methods. For example, pglogical performed up to 5 times faster than Slony and Londiste3 on OLTP workloads using pgbench.

For more details and access to binary packages for both the current stable release PostgreSQL 9.4 and the soon to be announced PostgreSQL 9.5 version, visit