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

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Dupe Key Violations in Logical Replication with PKs in Place
Дата
Msg-id EE079868-C5F8-48C2-8F79-10923D57B480@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Dupe Key Violations in Logical Replication with PKs in Place  (Don Seiler <don@seiler.us>)
Список 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 по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: Dupe Key Violations in Logical Replication with PKs in Place
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Update "usename" in pg_user