Keep sync_replication_slots as disabled on standby. --primary: SELECT 'init' FROM pg_create_logical_replication_slot('logicalslot', 'test_decoding', false, false, true); SELECT pg_log_standby_snapshot(); SELECT pg_log_standby_snapshot(); SELECT pg_log_standby_snapshot(); SELECT pg_log_standby_snapshot(); select pg_sleep(2); SELECT pg_replication_slot_advance('logicalslot', pg_current_wal_lsn()); select slot_name,database,xmin,catalog_xmin cxmin,restart_lsn,confirmed_flush_lsn flushLsn,wal_status,conflicting conf, failover,synced,temporary temp, active from pg_replication_slots order by slot_name; --standby: select pg_sync_replication_slots(); select pg_sync_replication_slots(); -- ERROR here