pglogical

AGGREGATE 

Accumulate changes from sharded database servers into a Data Warehouse

SCALE OUT 

Copy all or a selection of database tables to other nodes in a cluster

INTEGRATE

Feed database changes in real-time to other systems

Availability

(pglogical 2.2 released - March 20, 2018)

pglogical is available for PostgreSQL 9.4 - 10. It is available via 2ndQuadrant’s apt and yum repositories for Debian and Red Hat family (RHEL, CentOS, and Fedora). You can use standard apt and yum package managers for installing pglogical with your instance of PostgreSQL.

Detailed installation instructions are available here. 

Release notes are available here. 

You can also access pglogical's github repository. 

pglogical is fully open source, released under the PostgreSQL licence with copyright novated to the PostgreSQL Development Group. 

What benefits does pglogical provide?

• Synchronous replication
• Delayed replication
• Configurable conflict resolution
• Ability to convert physical standby to logical replication
• Can publish data from PostgreSQL to a Postgres-XL subscriber
• Sequences can be replicated
• No triggers means reduced write load on the Provider
• No re-execution of SQL means reduced overhead and latency for the Subscriber
• Subscriber isn’t in hot standby recovery, so you can use temp, unlogged, or normal tables
• No need to cancel queries to allow the replica to continue replay
• Subscriber can have different users & security, different indexes, different parameter settings
• Replicate just one database, or a subset of tables, known as Replication Sets
• Replicate across PostgreSQL versions or architectures, allowing low- or zero-downtime upgrades
• Multiple upstream servers into a single subscriber for change accumulation

How does pglogical work?

pglogical utilises the Logical Decoding features added by 2ndQuadrant (and available since PostgreSQL 9.4). pglogical works even faster with PostgreSQL 9.5 and newer, with low overhead on both provider and subscriber.

pglogical relies heavily on features introduced as part of BDR development, including:

• logical decoding
• replication slots
• static background workers
• replication origins
• commit timestamps
• logical WAL messages

Does pglogical replace Bi-Directional Replication (BDR)?

No. pglogical does not provide full multi-master replication features and consistent schema change support, as BDR does. pglogical incorporates features from BDR and lessons learned from BDR to produce a simpler and easier to use solution for one-way replication, usable by more people for a wide variety of use cases. BDR is designed first and foremost for n-way mesh multi-master, and this proved hard to adapt well to single-master one-way replication.

BDR  development will continue for those that require full multi-master capabilities, reusing much of the code from pglogical.