Search Postgresql Archives

Logical replication versus pglogical on PostgreSQL 14

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux