public inbox for [email protected]  

help / color / mirror / Atom feed

From: Arvind Raghuwanshi <[email protected]>
To: [email protected]
Subject: Regarding: Replication of TRUNCATE commands is not working
Date: Tue, 9 Apr 2024 14:50:10 +0530
Message-ID: <CAEmgyXU9RXhttnqxjcrN78WkAqo9DLwgro+R8ai8NyG4YS0g2g@mail.gmail.com> (raw)

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

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Regarding: Replication of TRUNCATE commands is not working
  In-Reply-To: <CAEmgyXU9RXhttnqxjcrN78WkAqo9DLwgro+R8ai8NyG4YS0g2g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox