Re: Logical replication stuck and no data being copied

2021-02-18 Thread anonymous001
After further investigation, I discovered the following. On aurora ( the subscriber). select now()::timestamp(0),a.subname,b.srsubstate,count(*) from pg_subscription_rel b, pg_subscription a where b.srsubid=a.oid group by 1,2,3 order by 2,3; now | subname | srsub

Logical replication stuck and no data being copied

2021-02-17 Thread anonymous001
I'm connecting from an aurora postgresql 12.4 instance to a postgresql 12.6 community edition. The postgresql 12.6 is the publisher and the aurora db is the subscriber. Most of the subscriptions and publishing worked. Except for one table, which I've created a separate publication for. One table