Re: Regarding publish_via_partiton_root with pglogical

2024-09-28 Thread Greg Sabino Mullane
Please do not spam the mailing lists with requests for follow ups. In this particular case, you received an answer two days after you posted it. It went to both psql-general, pgsql-in-general, and to you directly, so there seems little excuse for missing it. Also note that pglogical is a third-par

Re: Regarding publish_via_partiton_root with pglogical

2024-09-27 Thread Durgamahesh Manne
Hi Any inputs from the PGDG team members regarding this ? Regards Durga Mahesh On Mon, Jul 22, 2024 at 3:35 PM khan Affan wrote: > Hi Durgamahesh > > In pglogical extension, there is no direct equivalent to the > publish_via_partition_root option found in the built-in logical replication > > y

Re: Regarding publish_via_partiton_root with pglogical

2024-07-22 Thread khan Affan
Hi Durgamahesh In pglogical extension, there is no direct equivalent to the publish_via_partition_root option found in the built-in logical replication you can achieve similar results when a new partition is added; you must add it to the replication set using pglogical.replication_set_add_table.

Regarding publish_via_partiton_root with pglogical

2024-07-20 Thread Durgamahesh Manne
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 targ