MIME-Version: 1.0
References: <CAJCZkoLW8vhWbB6BZophZvkg2BmkpqbYj39kiYVdy9td5eQJQg@mail.gmail.com>
In-Reply-To: <CAJCZkoLW8vhWbB6BZophZvkg2BmkpqbYj39kiYVdy9td5eQJQg@mail.gmail.com>
From: khan Affan <bawag773@gmail.com>
Date: Mon, 22 Jul 2024 15:04:51 +0500
Message-ID: <CAF4emOkmPQLUDfKM5W5wov3aEVBzLdiJNLizDEAjLPgTDzQ=sQ@mail.gmail.com>
Subject: Re: Regarding publish_via_partiton_root with pglogical
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
Cc: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b01c54061dd32d1d"
Archived-At: <https://www.postgresql.org/message-id/CAF4emOkmPQLUDfKM5W5wov3aEVBzLdiJNLizDEAjLPgTDzQ%3DsQ%40mail.gmail.com>
Precedence: bulk

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

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.
Similarly existing partitions are reorganized or split, ensure to update
the replication sets accordingly.

Thanks & Regards


*Muhammad Affan (*=EC=95=84=ED=8C=90*)*

*PostgreSQL Technical Support Engineer** / Pakistan R&D*

Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan

On Sat, Jul 20, 2024 at 12:00=E2=80=AFPM Durgamahesh Manne <
maheshpostgres9@gmail.com> wrote:

> 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 =3D true); This will use parent table to repl=
ica
> 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
>

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

<div dir=3D"ltr">Hi=C2=A0Durgamahesh<div><br></div><div>In pglogical extens=
ion, there is no direct equivalent to the publish_via_partition_root option=
 found in the built-in logical replication<br><br>you can achieve similar r=
esults=C2=A0when a new partition is added; you must add it to the replicati=
on set using pglogical.replication_set_add_table. Similarly existing partit=
ions are reorganized or split, ensure to update the replication sets accord=
ingly.<br></div><div><br></div><div>Thanks &amp;=C2=A0Regards<br><br><table=
 width=3D"180px" style=3D"text-align:center;border-width:1px 2px 1px 1px;bo=
rder-style:solid;border-color:rgb(255,255,255) rgb(216,216,216) rgb(255,255=
,255) rgb(255,255,255)"><tbody><tr align=3D"center"><td style=3D"border:1px=
 solid rgb(255,255,255)"><img width=3D"96" height=3D"71" src=3D"https://ci3=
.googleusercontent.com/mail-sig/AIorK4xPDLoHVVvHOBlBBe0cMeIZnfE5Gg8-8_LKsSp=
Vq4Elp7C8VQOCzn4kW2pPgxDqKkaxcjv4W7k"><br></td></tr></tbody></table><p styl=
e=3D"line-height:1.2;margin-top:6pt;margin-bottom:6pt"><b><span style=3D"fo=
nt-family:Arial;color:rgb(34,85,255);background-color:transparent;vertical-=
align:baseline">Muhammad Affan (</span></b><span style=3D"background-color:=
transparent;vertical-align:baseline"><font color=3D"#2a363f" face=3D"ui-san=
s-serif, system-ui, -apple-system, BlinkMacSystemFont, Segoe UI, Roboto, He=
lvetica Neue, Arial, Noto Sans, sans-serif, Apple Color Emoji, Segoe UI Emo=
ji, Segoe UI Symbol, Noto Color Emoji"><span style=3D"font-size:16px">=EC=
=95=84=ED=8C=90</span></font><font color=3D"#2255ff" face=3D"Arial"><b>)</b=
></font></span></p><p dir=3D"ltr" style=3D"line-height:1.2;margin-top:6pt;m=
argin-bottom:6pt"><b><span style=3D"font-family:Arial;background-color:tran=
sparent;vertical-align:baseline"><font color=3D"#2255ff" size=3D"2">Postgre=
SQL Technical Support Engineer</font></span></b><b><span style=3D"font-fami=
ly:Arial;background-color:transparent;vertical-align:baseline"><font color=
=3D"#022ea9" style=3D"font-size:13.3333px">=C2=A0/ Pakistan R&amp;D</font><=
/span></b></p><p dir=3D"ltr" style=3D"line-height:1.2;margin-top:6pt;margin=
-bottom:6pt"></p><table width=3D"355px" align=3D"left" style=3D"border:1px =
solid rgb(255,255,255);margin-left:10px"><tbody><tr><td style=3D"font-famil=
y:Roboto,sans-serif;border:1px solid rgb(255,255,255)">Interlace Plaza 4th =
floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan</td></tr></tbody></t=
able></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"g=
mail_attr">On Sat, Jul 20, 2024 at 12:00=E2=80=AFPM Durgamahesh Manne &lt;<=
a href=3D"mailto:maheshpostgres9@gmail.com">maheshpostgres9@gmail.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=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><d=
iv>CREATE PUBLICATION dbz_publication FOR TABLE betplacement.bet WITH (publ=
ish_via_partition_root =3D true); This will use parent table to replica dat=
a changes to target from source=C2=A0<br></div><div>But</div><div>Could you=
 please=C2=A0provide a logic to implement the same with pglogical ?</div><d=
iv>Do i need to add this publish_via_partition_root to pglogical.replicatio=
n_set_add_table functionality ?</div><div>you response is valuable in this =
aspect=C2=A0</div><div><br></div><div>Regards,</div><div>Durga Mahesh</div>=
</div>
</blockquote></div>

--000000000000b01c54061dd32d1d--