wal2mongo

pig build pkg wal2mongo         # 构建 DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

wal_level = logical
max_replication_slots = 10

-- 创建逻辑复制槽
SELECT * FROM pg_create_logical_replication_slot('w2m_slot', 'wal2mongo');

-- 执行 DML 操作
CREATE TABLE books (id SERIAL PRIMARY KEY, title VARCHAR(100), author VARCHAR(100));
INSERT INTO books (id, title, author) VALUES (123, 'My Book', 'Author');

-- 查看变更（MongoDB 格式）
SELECT * FROM pg_logical_slot_peek_changes('w2m_slot', NULL, NULL);
-- 输出：db.books.insertOne( { id:123, title:"My Book", author:"Author" } )

-- 消费变更
SELECT * FROM pg_logical_slot_get_changes('w2m_slot', NULL, NULL);

-- 删除槽
SELECT pg_drop_replication_slot('w2m_slot');

pg_recvlogical -d postgres --slot w2m_slot --create-slot -P wal2mongo
pg_recvlogical -d postgres --slot w2m_slot --start -f -

// 复制 pg_logical_slot_get_changes 的输出
db.books.insertOne( { id:123, title:"My Book", author:"Author" } )

mongo < changes.js