本文介绍了在PostgreSQL中创建、使用和管理逻辑复制槽的过程，包括pg_create_logical_replication_slot,pg_replication_slots,pg_export_snapshot以及错误处理如logical_decoding在RECOVERY模式下的限制。最后展示了如何删除复制槽pg_drop_replication_slot。
pg_create_logical_replication_slot
select * from pg_replication_slots;
select pg_export_snapshot();
select pg_create_logical_replication_slot(‘logical_slot1’, ‘test_decoding’);
CREATE TABLE t_logical(id int4);
pg_logical_slot_get_changes
SELECT * FROM pg_logical_slot_get_changes(‘logical_slot1’, null, null);
pg_logical_slot_peek_changes
INSERT INTO t_logical VALUES (1);
SELECT * FROM pg_logical_slot_peek_changes(‘logical_slot1’, null, null);
ERROR: logical decoding cannot be used while in recovery
pg_drop_replication_slot
SELECT pg_drop_replication_slot(‘logical_slot1’);
扫一扫
3333
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
