Re: Logical Replication not working for few Tables

Поиск
Список
Период
Сортировка
От Padmakumar Kadayaprth
Тема Re: Logical Replication not working for few Tables
Дата
Msg-id CAMjUpCr9-ybmHj5OBN_4uDi3ZiSuyP4t0rUX_pLzMjRQAbWzug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical Replication not working for few Tables  ("Euler Taveira" <euler@eulerto.com>)
Список pgsql-bugs
Дерево обсуждения
I am using postgresql 11 on windows.it is native logical replication.

Unfortunately I deleted old logs before seeing this issue . Now replication is happening without any issue for all the  tables without any issue other than these  four table.So there is no error in the log.
I am really stuck . 

I am thinking of doing a work around.
After dropping four tables from publication, 
if i am creating four new tables ,import data from old tables to new tables ,drop old tables and rename newly created tables to the actual table name which i dropped and add it back to publication and refresh subscription .
Does this step help me in fixing this issue because the id of the relation will change even though I have the same table name. 
Any thoughts?


Thanks,
Padmakumar


On Fri, Nov 12, 2021 at 11:00 PM Euler Taveira <euler@eulerto.com> wrote:
On Fri, Nov 12, 2021, at 11:36 AM, Padmakumar Kadayaprth wrote:
   I configured  logical replication some time back .Now except for 4 table replication is happening.Few weeks back replication got stopped because of some conflict and these 4 tables were part of that conflict.  Someone resolved the conflict but replication has not started for these four tables .I dropped these tables from publication and added it back and refreshed the subscription but still replication is not happening for these four .  For testing I created a new table and added it to publication and refreshed subscription , that was sussues.
You didn't provide enough information. Is it native logical replication or
another tool (pglogical, Slony, etc)? What's the exact version?

Is there any system table where these 4 tables are marked as conflict and not to be replicated?
There is no system table/view that shows the conflicts. You have to inspect your
log files.

Why is replication not happening only to those four tables.is this a bug?
It is hard to guess without at least the error messages.


--
Euler Taveira

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