Re: table not found on publisher

2022-02-14 Thread Tom Lane
Radoslav Nedyalkov writes: > If the target is upgraded to pg13 then the initial copy goes fine. > Unfortunately it is a 40T db in a sunset, so we'd rather won't upgrade. Yeah, after looking at the code, pre-v13 versions simply don't know how to do initial sync from anything except a plain table.

Re: table not found on publisher

2022-02-14 Thread Radoslav Nedyalkov
Just an update. If the target is upgraded to pg13 then the initial copy goes fine. Unfortunately it is a 40T db in a sunset, so we'd rather won't upgrade. On Fri, Feb 11, 2022 at 4:50 PM Radoslav Nedyalkov wrote: > Hello All, > It is a bit specific logical replication setup where we try to repli

table not found on publisher

2022-02-11 Thread Radoslav Nedyalkov
Hello All, It is a bit specific logical replication setup where we try to replicate a partitioned table (pg14.1) to a non-partitioned one (pg11.14) After establishing everything the subscriber fails on the initial copy with ERROR: table "public.tab01" not found on publisher If the subscription i