pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.

Поиск
Список
Период
Сортировка
От milist ujang
Тема pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.
Дата
Msg-id CACG9ogxKd9f97YiTrdtcxKRS=gnNTeAU281TX9ky3qYtbDZFyA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip.  (milist ujang <ujang.milist@gmail.com>)
Список pgsql-general
Configured pglogical source is 9.4 target is 12.3

a table has PK from multiple column (varchar(50),char(2),char(1)).

initial syncronization is OK, but when at source there is delete , but got error at target...

LOG:  CONFLICT: remote DELETE on relation public.a_XXXX replica identity index a_XXX_pk (tuple not found). Resolution: skip.

replica identity was set to default for the table so yes there is old image on those 3 columns:

but why delete was error at target?
collation exactly same on all GUC.

any direction to print debug verbosity on why delete on target didnt find row and skipped?



--

В списке pgsql-general по дате отправления:

Предыдущее
От: raf
Дата:
Сообщение: Re: Implement a new data type
Следующее
От: Amul Sul
Дата:
Сообщение: Re: Sizing PostgreSQL VM server sizing