Re: Help diagnosing replication (copy) error

On Sun, Mar 10, 2024 at 3:16 AM Adrian Klaver wrote: > > Is the case still active? > Can you get information from them about what they saw? > > I've re-opened the case and asked for an explanation of the error and what they did to resolve it. Hopefully they shed some light on the 'mystery'.

Re: Help diagnosing replication (copy) error

On 3/8/24 22:26, Steve Baldwin wrote: On Sat, Mar 9, 2024 at 11:06 AM Jeff Ross > wrote: RDS is a black box--who knows what's really going on there?  It would be interesting to see what the response is after you open a support case. I hope you'll

Re: Help diagnosing replication (copy) error

On Sat, Mar 9, 2024 at 11:06 AM Jeff Ross wrote: > > RDS is a black box--who knows what's really going on there? It would be > interesting to see what the response is after you open a support case. > I hope you'll be able to share that with the list. > > This is very mysterious. I logged the

Re: Help diagnosing replication (copy) error

On 3/8/24 14:50, Steve Baldwin wrote: Hi, I'm in the process of migrating a cluster from 15.3 to 16.2. We have a 'zero downtime' requirement so I'm using logical replication to create the new cluster and then perform the switch in the application. I have a situation where all but one table

Re: Help diagnosing replication (copy) error

On Sat, Mar 9, 2024 at 9:13 AM Adrian Klaver wrote: > > I should been clearer. > > What are the CREATE PUBLICATION and CREATE SUBSCRIPTION statements? > > The publications were created a while ago. Does this help: b2bcreditonline=> select * from pg_publication; -[ RECORD 1 ]+-

Re: Help diagnosing replication (copy) error

On 3/8/24 14:04, Steve Baldwin wrote: On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver > wrote: What are the rest of the values in pg_replication_slots? b2bcreditonline=> select * from pg_replication_slots;                   slot_name                  |  

Re: Help diagnosing replication (copy) error

On 3/8/24 14:04, Steve Baldwin wrote: On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver > wrote: What are the rest of the values in pg_replication_slots? b2bcreditonline=> select * from pg_replication_slots;                   slot_name                  |  

Re: Help diagnosing replication (copy) error

On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver wrote: > > What are the rest of the values in pg_replication_slots? > > b2bcreditonline=> select * from pg_replication_slots; slot_name | plugin | slot_type | datoid |database | temporary | active |

Re: Help diagnosing replication (copy) error

On 3/8/24 13:50, Steve Baldwin wrote: Hi, I'm in the process of migrating a cluster from 15.3 to 16.2. We have a 'zero downtime' requirement so I'm using logical replication to create the new cluster and then perform the switch in the application. I have a situation where all but one table

Help diagnosing replication (copy) error

Hi, I'm in the process of migrating a cluster from 15.3 to 16.2. We have a 'zero downtime' requirement so I'm using logical replication to create the new cluster and then perform the switch in the application. I have a situation where all but one table have done their initial copy. The remaining