Presented by:

1299b89b8b3f683a581bcf502fd0205a

Peter Eisentraut

2ndQuadrant

Peter has been a contributor to PostgreSQL development since 1999. He is a committer, core team member, and is involved in many aspects of the community.

He works at 2ndQuadrant, a global service and support provider for PostgreSQL.

No video of the event yet, sorry!

This talk will present the PostgreSQL replication solutions pglogical 3 and BDR 3.

pglogical is a PostgreSQL extension for logical replication between two nodes. Most of the code for built-in logical replication in PostgreSQL 10 was derived from pglogical, while pglogical offers a larger feature set, such as row and column filtering, conflict resolution, and compatibility back to PostgreSQL 9.4. The new major release pglogical 3 was rearchitected to support even more functionality including failover support, improved table synchronization, and Kafka integration.

BDR is a PostgreSQL extension for asynchronous multimaster replication. The upcoming BDR 3 was completely reengineered and built on top of pglogical 3. It will support multiple consistency models, new node management, and transparent DDL replication.

Date:
2018 April 20 10:50 EDT
Duration:
50 min
Room:
Enterprise
Conference:
PostgresConf US 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Medium