Tom Lane schrieb am 20.07.2020 um 20:04: > Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
