How to Fix Activate Stuck with Creating Replication Slot in PostgreSQL Source Location
Issue
When you activate the channel, the job may remain stuck in the Running
state on a PostgreSQL source location.
Environment
HVR 6
Resolution
To reduce the chances of Activate Replication remaining stuck due to database lock contention, we recommend that you activate the channel during off-peak or outside-business hours, when the PostgreSQL source database is less busy.
Run the following query, or use the Lock Manager database management tool, to check whether replication slot creation is blocked:
SELECT * FROM pg_stat_activity WHERE query LIKE '%pg_create_logical_replication_slot%';
Cause
This issue occurs when replication slot creation is blocked and is waiting for other database processes or locks to be released.