2.7.测试你的 BDR(启用)系统

  1. 在第一个节点上创建表, 并插入数据:
    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;
  1. 在你的第二个节点/实例上检查行, 现在删除一行,做相关检查:

     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;
    
  2. 检查第一个节点上这一行是否已经删除:

     psql -p 5598 -U postgres bdrdemo
       -- you will see one row
       SELECT * FROM t1bdr;
    

results matching ""

    No results matching ""