Troubleshooting · Replication · Geo · Administration · Help · GitLab

ERROR: could not create replication slot localharvest: ERROR: logical decoding cannot be used while in recovery SELECT slot_name, slot_type, active

Failing to do so will make the replication slot stuck at its current position, the publisher node will start accumulating WALs and inevitably

error slot pid 23992 status

error 1089 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