Re: Tables getting stuck at 's' state during logical replication

2023-05-05 Thread Padmavathi G
they were stuck, these replication origins were not removed. On Fri, May 5, 2023 at 4:04 PM Amit Kapila wrote: > On Fri, May 5, 2023 at 3:04 PM Padmavathi G > wrote: > > > > Hello, > > I am trying out logical replication for upgrading postgres instance from > version 1

Tables getting stuck at 's' state during logical replication

2023-05-05 Thread Padmavathi G
Hello, I am trying out logical replication for upgrading postgres instance from version 11 to 15.x. In the process, I noticed that some tables get stuck in the 's' state during logical replication and they do not move to the 'r' state. I tried to drop the subscription and create a new subscriber, b