--- Создает слоты логической репликации на мастере
--- psql -d dbname -U postgres -f slots_create.sql
--- */1	*	*	*	*	psql -d dbname -U postgres -f ~/slots/slots_create.sql > /dev/null 2>&1
--- 
select 
pg_create_logical_replication_slot(s.name, 'pgoutput') 
from (
  values
    ('slot1_sub')
   ,('slot2_sub')
   ,('slot3_sub')
   ,('slot4_sub')
  ) s(name) 
where 
  not pg_is_in_recovery() and
  not exists (select 1 from pg_replication_slots where slot_type='logical' and slot_name=s.name);
  

--- Удаляет слоты если сервер реплика
--- --- psql -d dbname -U postgres -f slots_drop.sql
--- */1	*	*	*	*	psql -d dbname -U postgres -f ~/slots/slots_drop.sql > /dev/null 2>&1
---
select 
  pg_drop_replication_slot(s.name) 
from (
  values
    ('slot1_sub')
   ,('slot2_sub')
   ,('slot3_sub')
   ,('slot4_sub')
  ) s(name) 
where 
  pg_is_in_recovery() and
  exists (select 1 from pg_replication_slots where slot_type='logical' and slot_name=s.name);