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