MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Fri, 13 Sep 2024 01:34:40 +0530
Message-ID: <CAJCZkoKCryPoaKFeL=8rT0=SmsTzivQKv6C79wVD7=ufAwLF_g@mail.gmail.com>
Subject: pglogical selective child replication between different partition
 interval tables
To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org, 
	Greg Sabino Mullane <htamfids@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000d124090621f194c0"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoKCryPoaKFeL%3D8rT0%3DSmsTzivQKv6C79wVD7%3DufAwLF_g%40mail.gmail.com>
Precedence: bulk

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

Hi Respected Team
Here source side tables are created with 7 days partition interval here we
have data within them

changelog_event_p20240830
changelog_event_p20240906


Target side tables are created with 3 days partition interval
Structure of tables at both side is same

Would it be possible to replicate selective child table
(changelog_event_p20240906)  to target with logical replication or pglogical

create publication with where clause does work in this scenario?

Regards.
Durga Mahesh

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

<div dir=3D"ltr">Hi Respected Team<div>Here source side tables are created =
with 7 days partition interval here we have data within them=C2=A0</div><di=
v><br></div><div>changelog_event_p20240830 <br>changelog_event_p20240906 <b=
r>=C2=A0<br></div><div><br></div><div>Target side tables are created with 3=
 days partition interval=C2=A0</div><div>Structure=C2=A0of tables at both s=
ide is same=C2=A0<br></div><div><br></div><div>Would it be possible to repl=
icate selective child table (changelog_event_p20240906)=C2=A0 to target wit=
h logical replication or pglogical</div><div><br></div><div>create publicat=
ion with where clause does work in this scenario?</div><div><br></div><div>=
Regards.</div><div>Durga Mahesh=C2=A0</div><div><br></div><div><br></div><d=
iv><br></div></div>

--000000000000d124090621f194c0--