Logical replication versus pglogical on PostgreSQL 14

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

Responses

Browse pgsql-general by date

  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