Postgresql 11 logical replication - stuck in `catchup` state

Slot-Based Query Execution Engine · Stable API · System Collections · Legacy The log message verbosity level for components related to replication See

Postgresql 11 logical replication - stuck in `catchup` state Replication slot is not active for a standby or replication data lagging values are null Meaning: The standby replication slot active flag value is false or

Slot-Based Query Execution Engine · Stable API · System Collections · Legacy The log message verbosity level for components related to replication See

replication slot is active for pid 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

Confirm that the connector has created a new replication slot and that it is in active state by querying the pg_replication_slots table Resume the write

replication slot does not exist Postgres prevents active slots from being dropped If it does happen , PowerSync would

To resolve these errors, remove the used replication slots, or increase the value of the max_replication_slots parameter Resolution Remove used replication