Regarding: Replication of TRUNCATE commands is not working

From: Arvind Raghuwanshi <arvindcs28(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Regarding: Replication of TRUNCATE commands is not working
Date: 2024-04-09 09:20:10
Message-ID: CAEmgyXU9RXhttnqxjcrN78WkAqo9DLwgro+R8ai8NyG4YS0g2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajan Pandey 2024-04-09 10:19:39 Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options
Previous Message Sebastien Flaesch 2024-04-08 17:44:01 Re: prepared statement "cu1" already exists (but it does not)