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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Don Seiler <don(at)seiler(dot)us>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, 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:15:03
Message-ID: EE079868-C5F8-48C2-8F79-10923D57B480@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Nov 14, 2023, at 9:12 AM, Don Seiler <don(at)seiler(dot)us> wrote:
>
> That's precisely why I'm using logical replication for this migration. The indexes are new on the subscriber server. Re-indexing should only be necessary if I were to do physical replication/restore onto a 22.04 server, no?

As far as I know, you are right about that--I missed the part where you said logical replication onto new clusters.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-11-14 16:42:00 Re: Update "usename" in pg_user
Previous Message Don Seiler 2023-11-14 16:14:02 Re: Dupe Key Violations in Logical Replication with PKs in Place