From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Logical replication versus pglogical on PostgreSQL 14 |
Date: | 2022-07-23 09:09:40 |
Message-ID: | Ytu61DD4deIh+bud@campbell-lange.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ludwig Isaac Lim | 2022-07-23 10:04:24 | Strange behavior between timestamp and date comparison |
Previous Message | Techsupport | 2022-07-23 04:27:53 | RE: 20220722-pg_dump: error: invalid number of parents 0 for table |