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: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.