Re: Logical replication from 11.x to 12.x and "unique key violations" - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Logical replication from 11.x to 12.x and "unique key violations"
Date
Msg-id 76af9b83-74cc-88b5-23a7-0462774f472d@gmx.net
Whole thread Raw
In response to Logical replication from 11.x to 12.x and "unique key violations"  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: Logical replication from 11.x to 12.x and "unique key violations"
Re: Logical replication from 11.x to 12.x and "unique key violations"
List pgsql-general
> I have a strange error when using logical replication between a 11.2
> source database and a 12.3 target.
>
> If I create the publication with all needed tables (about 50) at
> once, I get "duplicate key value violates unique constraint xxx_pkey"
> errors during the initial replication (when creating the
> subscription).
>
> When create the publication only with a few tables, the initial data
> sync works without problems. To replicate all tables, I add the
> tables incrementally to the publication, and refresh the
> subscription.
>
> If I do it like that (step-by-step) everything works fine. Tables
> that generated the "duplicate key value" error previously will
> replicate just fine. The tables are quite small, some of them less
> then 100 rows.
>

Any pointers where I should start looking to investigate this?




pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: PGBench on Windows - connections are subprocesses?
Next
From: Michel Pelletier
Date:
Subject: Re: how to "explain" some ddl