Re: Logical replication and truncate table

Hi

We are using Pg V10 , streaming , async

On Wed, Dec 23, 2020 at 7:04 PM Jerry Sievers <gsievers19(at)comcast(dot)net>
wrote:

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