Re: Dupe Key Violations in Logical Replication with PKs in Place - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Dupe Key Violations in Logical Replication with PKs in Place
Date
Msg-id EE079868-C5F8-48C2-8F79-10923D57B480@elevated-dev.com
Whole thread Raw
In response to Re: Dupe Key Violations in Logical Replication with PKs in Place  (Don Seiler <don@seiler.us>)
List pgsql-admin
> On Nov 14, 2023, at 9:12 AM, Don Seiler <don@seiler.us> wrote:
>
> That's precisely why I'm using logical replication for this migration. The indexes are new on the subscriber server.
Re-indexingshould 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.


pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: Dupe Key Violations in Logical Replication with PKs in Place
Next
From: Laurenz Albe
Date:
Subject: Re: Update "usename" in pg_user