PostgreSQL 原生逻辑复制 Publication/Subscription 实战

前置配置（postgresql.conf）：wal_level = logical max_wal_senders = 10 max_replication_slots = 10 发布端创建 Publication：CREATE PUBLICATION pub_all FOR ALL TABLES; -- 或指定表： -- CREATE PUBLICATION pub_sel FOR TABLE public.users, public.orders; 订阅端创建 Subscription：CREATE SUBSCRIPTION sub_all CONNECTION 'host=pub-db port=5432 dbname=app user=replicator password=secret' PUBLICATION pub_all WITH (copy_data = true, create_slot = true, slot_name = 'sub_all', enabled = true, synchronous_commit = 'local'); 状态监控与刷新：SELECT * FROM pg_stat_subscription; ALTER SUBSCRIPTION sub_all REFRESH PUBLICATION WITH (copy_data = false); 启停订阅：ALTER SUBSCRIPTION sub_all DISABLE; ALTER SUBSCRIPTION sub_all ENABLE;