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

2023-05-10 Thread Bharath Rupireddy
On Tue, May 9, 2023 at 4:38 PM Amit Kapila wrote: > > On Fri, May 5, 2023 at 7:27 PM Padmavathi G wrote: > > > > Some background on the setup on which I am trying to carry out the upgrade: > > > > We have a pod in a kubernetes cluster which contains the postgres 11 image. > > We are following

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

2023-05-09 Thread Amit Kapila
On Fri, May 5, 2023 at 7:27 PM Padmavathi G wrote: > > Some background on the setup on which I am trying to carry out the upgrade: > > We have a pod in a kubernetes cluster which contains the postgres 11 image. > We are following the logical replication process for upgrade > > Steps followed for

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

2023-05-05 Thread Padmavathi G
Some background on the setup on which I am trying to carry out the upgrade: We have a pod in a kubernetes cluster which contains the postgres 11 image. We are following the logical replication process for upgrade Steps followed for logical replication: 1. Created a new pod in the same

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

2023-05-05 Thread Amit Kapila
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 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' >

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,