1. 主库查看有哪些发布
    3. select * from pg_publication;  
    5. 查看订阅发布情况
    6. select * from pg_stat_replication ;
    10. 查看订阅状态
    12. SELECT slot_name,plugin,slot_type,database,active,restart_lsn    FROM pg_replication_slots where slot_name='obd_sub';
    14. 如果状态为false订阅端需要刷新
    1. 从库查看订阅
    3. select * from pg_subscription;
    5. alter subscription mysub connection 'host=localhost port=5433 dbname=postgres';ALTER SUBSCRIPTION