Postgres Pro
Downloads
Home   >   mailing lists

Logical replication and truncate table - Mailing list pgsql-admin

From Yambu
Subject Logical replication and truncate table
Date
Msg-id CALhHtcCP2RBR5bsnRA3nYLXF1qdUhbFRGU3+=DRFC_SNYDLscg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
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?

pgsql-admin by date:

Previous
From: Kasahara Tatsuhito
Date:
Subject: Re: Error: "could not fork new process for connection: Cannot allocate memory"
Next
From: Jerry Sievers
Date:
Subject: Re: Logical replication and truncate table