Re: Logical replication 'possible' problem

2022-05-04 Thread Steve Baldwin
The logical replication dump of the table I thought was 'stuck' eventually completed after 6+ hours. I guess the replication slot showing active as false is to be expected. I never noticed it before. So there never was an issue - apart from my ignorance. Sorry for the noise. Cheers, Steve On

Re: Logical replication 'possible' problem

2022-05-03 Thread Steve Baldwin
Sorry, I should have added the publisher is on 13.1 and the subscriber 14.2. Both are AWS RDS instances. I checked the log files for the publisher and subscriber and couldn't see any logical replication errors. The publisher is a busy DB though so if there are any errors there, I may have missed

Logical replication 'possible' problem

2022-05-03 Thread Steve Baldwin
Hi, I'm in the process of doing the initial syncing of a subscriber with a publisher. There is only one table that is still in a 'dumping' state. It is quite a large table and in previous executions it took several hours. I'm not sure if it encountered a problem and stopped or if it is still