MIME-Version: 1.0
From: Arvind Raghuwanshi <arvindcs28@gmail.com>
Date: Tue, 9 Apr 2024 14:50:10 +0530
Message-ID: <CAEmgyXU9RXhttnqxjcrN78WkAqo9DLwgro+R8ai8NyG4YS0g2g@mail.gmail.com>
Subject: Regarding: Replication of TRUNCATE commands is not working
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000081da960615a66ee5"
Archived-At: <https://www.postgresql.org/message-id/CAEmgyXU9RXhttnqxjcrN78WkAqo9DLwgro%2BR8ai8NyG4YS0g2g%40mail.gmail.com>
Precedence: bulk

--00000000000081da960615a66ee5
Content-Type: text/plain; charset="UTF-8"

Hi,
I have tried to run the TRUNCATE command  and found out that it's not
getting replicated using logical replication for pgsql.
I have also checked the schema change using pg_dump command but the schema
change also not getting detected for TRUNCATE command.

However on pgsql logical replication doc page[1] , it's mentioned
that Replication of TRUNCATE commands is supported.

[1] PostgreSQL: Documentation: 16: 31.6. Restrictions
<https://www.postgresql.org/docs/current/logical-replication-restrictions.html>

Any idea how we can solve this?

Thanks
Arvind

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hi,<div=
>I have tried to run the TRUNCATE command=C2=A0 and found out that it&#39;s=
 not getting replicated using logical replication for pgsql.</div><div>I ha=
ve also checked the schema change using pg_dump command but the schema chan=
ge also not getting detected for TRUNCATE command.</div><div><br></div><div=
>However on pgsql logical replication doc page[1] , it&#39;s mentioned that=
=C2=A0Replication of TRUNCATE commands is supported.</div><div><br></div><d=
iv>[1]=C2=A0<a href=3D"https://www.postgresql.org/docs/current/logical-repl=
ication-restrictions.html">PostgreSQL: Documentation: 16: 31.6.=C2=A0Restri=
ctions</a><br></div><div><br></div><div>Any idea how we can solve=C2=A0this=
?</div><div><br></div><div>Thanks</div><div>Arvind</div></div></div></div><=
/div>

--00000000000081da960615a66ee5--