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