pglogical 2: Advanced Logical Replication for PostgreSQL
pglogical 2 is an advanced extension for PostgreSQL that enables logical streaming replication through a flexible publish/subscribe model. It leverages cutting-edge features for multi-node data synchronization, supporting diverse use cases such as major version upgrades, selective replication, and conflict resolution, making it a vital tool for database administrators managing complex PostgreSQL environments.
Features
Supports logical streaming replication with a publish/subscribe model.
Allows selective replication of tables, rows, and columns.
Facilitates upgrades between major PostgreSQL versions.
Employs automatic and configurable conflict resolution.
Utilizes advanced features like cascading replication and DDL command replication in enterprise settings.