Re: Logical replication and truncate table

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical replication and truncate table
Date: 2020-12-23 17:03:52
Message-ID: 87v9cslaiv.fsf@jsievers.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yambu <hyambu(at)gmail(dot)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(dot)consulting(at)comcast(dot)net

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-12-24 07:24:15 Re: Logical replication and truncate table
Previous Message Yambu 2020-12-23 15:21:58 Logical replication and truncate table