Re: Dupe Key Violations in Logical Replication with PKs in Place

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
Date: 2023-11-14 16:09:28
Message-ID: 5181C120-C6B2-4186-BB67-2B22660D5A7B@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Nov 14, 2023, at 9:04 AM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> What data type(s) in those columns, and what locale on each server? Maybe the change from 18.04/12 to 22.04/15 has caused some weirdness with "foreign" characters.

Problems with the locale updates are not limited to non-ASCII characters, sorting rules involving "-" changed, for instance. When you make that OS upgrade, you really, really, need to reindex all text types.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2023-11-14 16:10:05 Re: Dupe Key Violations in Logical Replication with PKs in Place
Previous Message Ron 2023-11-14 16:04:28 Re: Dupe Key Violations in Logical Replication with PKs in Place