pg_failover_slots

pig build pkg pg_failover_slots;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_failover_slots;		# install via package name, for the active PG version

pig install pg_failover_slots -v 18;   # install for PG 18
pig install pg_failover_slots -v 17;   # install for PG 17
pig install pg_failover_slots -v 16;   # install for PG 16
pig install pg_failover_slots -v 15;   # install for PG 15
pig install pg_failover_slots -v 14;   # install for PG 14

shared_preload_libraries = 'pg_failover_slots';

shared_preload_libraries = 'pg_failover_slots'

hot_standby_feedback = on
primary_slot_name = 'my_physical_slot'  -- must be non-empty

# Which slots to synchronize (default: all logical slots)
pg_failover_slots.synchronize_slot_names = 'name_like:%'

# Synchronize specific slots
pg_failover_slots.synchronize_slot_names = 'my_slot,plugin:test_decoding'

# Drop extra slots on standby not found on primary (default: true)
pg_failover_slots.drop_extra_slots = true

# Connection string to primary (default: uses primary_conninfo)
pg_failover_slots.primary_dsn = 'host=primary dbname=mydb'

# Ensure physical standbys receive data before logical consumers
pg_failover_slots.standby_slot_names = 'standby_physical_slot'

# How many standby slots must confirm (default: -1 = all)
pg_failover_slots.standby_slots_min_confirmed = -1

# Sync interval in ms (default: 60000)
pg_failover_slots.worker_nap_time = 60000

-- On standby: all slots should show active = false
SELECT slot_name, active FROM pg_replication_slots WHERE slot_type = 'logical';

--  slot_name        | active
-- ------------------+--------
--  regression_slot1 | f        -- synchronized, ready
--  regression_slot2 | f        -- synchronized, ready
--  regression_slot3 | t        -- still syncing, NOT ready