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

Tom Lane schrieb am 20.07.2020 um 20:04:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>> I'm probably missing something, but would that not result in a 'key not
>> found' type of error. The OP is seeing "duplicate key value violates
>> unique constraint xxx_pkey". To me that indicates a doubling up of at
>> least some of the data replication.
>
> [ squint... ]  Sorry, I completely misread the error condition.
>
> Yeah, duplicate keys does seem odd here.  Can you provide a self
> contained example?

I'll try, but this is a production system.
Extracting the necessary anonymous data will be tricky.

Is there any chance the version difference might cause this?
And a slightly outdated 11.x at that?

Thomas