MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sat, 20 Jul 2024 12:31:04 +0530
Message-ID: <CAJCZkoLW8vhWbB6BZophZvkg2BmkpqbYj39kiYVdy9td5eQJQg@mail.gmail.com>
Subject: Regarding publish_via_partiton_root with pglogical
To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e1b5d0061da85baf"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoLW8vhWbB6BZophZvkg2BmkpqbYj39kiYVdy9td5eQJQg%40mail.gmail.com>
Precedence: bulk

--000000000000e1b5d0061da85baf
Content-Type: text/plain; charset="UTF-8"

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

--000000000000e1b5d0061da85baf
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><div><br></div><div>Respected Team=C2=A0</div=
><div><br></div><div>I know the use case of implementing the partitions=C2=
=A0with publication and subscription of built-in logical replication=C2=A0<=
/div><div>CREATE PUBLICATION dbz_publication FOR TABLE betplacement.bet WIT=
H (publish_via_partition_root =3D true); This will use parent table to repl=
ica data changes to target from source=C2=A0<br></div><div>But</div><div>Co=
uld you please=C2=A0provide a logic to implement the same with pglogical ?<=
/div><div>Do i need to add this publish_via_partition_root to pglogical.rep=
lication_set_add_table functionality ?</div><div>you response is valuable i=
n this aspect=C2=A0</div><div><br></div><div>Regards,</div><div>Durga Mahes=
h</div></div>

--000000000000e1b5d0061da85baf--