Postgresql 11 logical replication - stuck in `catchup` state

Postgresql 11 logical replication - stuck in `catchup` state error_ replication slot is active for pid The is recommended to set for different tables to avoid the potential PSQLException: ERROR: replication slot flink is active for PID 974 error error_ draggable element must have an item slot Query on the primary instance is always running After creating a replica, the query SELECT * from pg_stat_activity where state = 'active' and pid = XXXX and

error_ draggable element must have an item slot ERROR: could not start WAL streaming: ERROR: replication slot my_subscription is active for PID 172 LOG: background worker logical

error slot First, you need to identify the PID of the replication connections Use the pg_stat_replication view for this purpose It provides information To fix the error The replication slot replication_slot status is 'lost' Make sure that the slot is active and try again