2.7.测试你的 BDR(启用)系统
- 在第一个节点上创建表, 并插入数据:
psql -p 5598 -U postgres bdrdemo
CREATE TABLE t1bdr (c1 INT, PRIMARY KEY (c1));
INSERT INTO t1bdr VALUES (1);
INSERT INTO t1bdr VALUES (2);
-- you will see two rows
SELECT * FROM t1bdr;
在你的第二个节点/实例上检查行, 现在删除一行,做相关检查:
psql -p 5599 -U postgres bdrdemo -- you will see two rows SELECT * FROM t1bdr; DELETE FROM t1bdr WHERE c1 = 2; -- you will see one row SELECT * FROM t1bdr;检查第一个节点上这一行是否已经删除:
psql -p 5598 -U postgres bdrdemo -- you will see one row SELECT * FROM t1bdr;