Regarding publish_via_partiton_root with pglogical

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org
Subject: Regarding publish_via_partiton_root with pglogical
Date: 2024-07-20 07:01:04
Message-ID: CAJCZkoLW8vhWbB6BZophZvkg2BmkpqbYj39kiYVdy9td5eQJQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-in-general

Hi

Respected Team

I know the use case of implementing the partitions with publication and
subscription of built-in logical replication
CREATE PUBLICATION dbz_publication FOR TABLE betplacement.bet WITH
(publish_via_partition_root = true); This will use parent table to replica
data changes to target from source
But
Could you please provide a logic to implement the same with pglogical ?
Do i need to add this publish_via_partition_root to
pglogical.replication_set_add_table functionality ?
you response is valuable in this aspect

Regards,
Durga Mahesh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sivapostgres@yahoo.com 2024-07-20 11:44:22 Re: Re. Select with where condition times out
Previous Message Dimitrios Apostolou 2024-07-19 19:33:35 Re: Query on partitioned table needs memory n_partitions * work_mem

Browse pgsql-in-general by date

  From Date Subject
Next Message Muhammad Imtiaz 2024-07-22 04:59:53 Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
Previous Message Durgamahesh Manne 2024-07-19 14:56:37 Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()