From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
Date: Tue, 14 Nov 2023 09:09:28 -0700
Message-ID: <5181C120-C6B2-4186-BB67-2B22660D5A7B@elevated-dev.com> (raw)
In-Reply-To: <401c360a-ff4c-4904-8608-22b24b2179d6@gmail.com>
References: <CAHJZqBC_mnKAH_vwep8cmVqyLhnj1CN+tc36kt73VBXpK_Etsg@mail.gmail.com>
<401c360a-ff4c-4904-8608-22b24b2179d6@gmail.com>
> On Nov 14, 2023, at 9:04 AM, Ron <ronljohnsonjr@gmail.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
In-Reply-To: <5181C120-C6B2-4186-BB67-2B22660D5A7B@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox