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
