Re: Logical Replication not working for few Tables

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(at)eulerto(dot)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
> EDB https://www.enterprisedb.com/
>
>