Logical replication and truncate table

From: Yambu <hyambu(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Logical replication and truncate table
Date: 2020-12-23 15:21:58
Message-ID: CALhHtcCP2RBR5bsnRA3nYLXF1qdUhbFRGU3+=DRFC_SNYDLscg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

Please confirm this , truncate a table on master db does not work well
wilth logical replication?
It results in duplicate key errors on slave right?

We should rather use delete from table?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2020-12-23 17:03:52 Re: Logical replication and truncate table
Previous Message Kasahara Tatsuhito 2020-12-23 03:18:23 Re: Error: "could not fork new process for connection: Cannot allocate memory"