We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Next generation PostgreSQL replication with pglogical 3 and BDR 3

118
 Cite
 Share
 Related Material
 Download
 Purchase
No logo availablePGCon - PostgreSQL Conference for Users and Developers
 Eisentraut, Peter

Formal Metadata

Title
Next generation PostgreSQL replication with pglogical 3 and BDR 3
Title of Series
Number of Parts
37
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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.