Обсуждение: Logical replication versus pglogical on PostgreSQL 14
I'm keen to learn of the differences between logical replication in PostgreSQL 14 and how this is different from the pglogical extension. Our intended use case is to have 200-300 publishers off many small databases aggregating to 20-30 central databases on another PostgreSQL instance on the same machine. My questions are: Is native logical replication and pglogical replication fundamentally the same? Is pglogical likely to be continue to be supported? Is there a roadmap for including more pglogical functionality in native logical replication? The following pglogical management functions seem particularly useful to our use case: * pglogical.replicate_ddl_command sync publisher ddl changes with subscriber * pglogical.alter_subscription_synchronize pglogical.wait_for_subscription_sync_complete/ pglogical.wait_slot_confirm_lsn sync subscription tables * pglogical.wait_slot_confirm_lsn assess if all subscribers are up-to-date (monitoring this in native logical replication seems tricky) Thanks for any comments Rory
On Saturday, July 23, 2022, Rory Campbell-Lange wrote: > Is native logical replication and pglogical replication fundamentally > the same? Here is a discussion about the differences between pglogical 2.1 and logical replication in PostgreSQL 10: <https://www.2ndquadrant.com/en/blog/pglogical-logical-replication-postgresql-10/> As far as I can tell, pglogical provides more features than the builtin logical replication in PostgreSQL (row/column filtering as an example). > Is pglogical likely to be continue to be supported? The link above says so: | First, let me assure you that the development of pglogical continues. Furthermore, the last release is from Dec, 2021 and the last commit is 12 days ago, <https://github.com/2ndQuadrant/pglogical>. -- Christian Barthel