Re: Logical replication and truncate table - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: Logical replication and truncate table
Date
Msg-id 87v9cslaiv.fsf@jsievers.enova.com
Whole thread Raw
In response to Logical replication and truncate table  (Yambu <hyambu@gmail.com>)
Responses Re: Logical replication and truncate table  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Yambu <hyambu@gmail.com> writes:

> 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?

Trunc has been supported in native logical replication since V11.

Start by telling us what Pg version you're on and what logical
replication your using.

See the docs.
>
> We should rather use delete from table?
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net



pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: Logical replication and truncate table
Next
From: Yambu
Date:
Subject: Re: Logical replication and truncate table