Awesome

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication. For more details, please visit: https://www.2ndquadrant.com/en/resources/pglogical/.

The pglogical 2 release brings new features allowing it to be used for even more use-cases and also several bug fixes and behavior improvements listed below:

• PG 11 support
• Improved compatibility with pglogical 1.x provider
• Improved error reporting
• Row filtering on provider
• Column filtering on provider
• Delayed replication
• MS Windows support (source code only)
• Ability to convert physical standby to logical replication
• Can publish data from PostgreSQL to a Postgres-XL subscriber
• Greatly improved performance for replication of large INSERT/COPY transactions
• Improved memory management.

pglogical 2's maintenance happens on the REL2_x_STABLE branch.

pglogical3 is currently only available for 2ndQuadrant support customers. Follow the 2ndQuadrant blog (https://blog.2ndquadrant.com/) and info@2ndquadrant.com or the bdr/pglogical forum and mailing list at https://groups.google.com/a/2ndquadrant.com/forum/#!forum/bdr-list for updates.