Logical replication slots stuck in catchup on a very large table

error_ replication slot is active for pid   Dan error slot

1 Answer You cannot start two WAL sender processes with the same replication slot If you need two clients to run logical decoding, create two

Examples Advancing a physical replication slot: postgres=# SELECT slot_name, slot_type, active, restart_lsn, confirmed_flush_lsn FROM pg_replication_slotsgx ERROR: could not create replication slot localharvest: ERROR: logical decoding cannot be used while in recovery SELECT slot_name, slot_type, active

alpha slot login This occurs when PostgreSQL does not have a replication slot for the secondary by that name You may want to rerun the replication process on the secondary How Connect ERROR: logical replication target relation has neither REPLICA IDENTITY