PGCon2018 - 2.5
PGCon 2018
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Peter Eisentraut |
| Schedule | |
|---|---|
| Day | Talks - Day 1: Thursday - 2018-05-31 |
| Room | DMS 1160 |
| Start time | 15:15 |
| Duration | 00:45 |
| Info | |
| ID | 1188 |
| Event type | Lecture |
| Track | Scaling Out |
| Language used for presentation | English |
Next generation PostgreSQL replication with pglogical 3 and BDR 3
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.