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