postgres=# select * from pgxc_node;
node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred | node_id
-----------+-----------+-----------+-------------+----------------+------------------+------------
datanode1 | D | 20008 | 10.21.13.67 | t | t | 888802358
datanode2 | D | 20008 | 10.21.13.60 | f | f | -905831925
coord1 | C | 20004 | 10.21.13.67 | f | f | 1885696643
13. 建表测试
postgres=# create table test(id integer,name varchar(10));
postgres=# insert into test(id,name) values(1,'test');
postgres=# insert into test(id,name) values(2,'test');
查询结果
postgres=# select * from test;
id | name
----+------
1 | test
2 | test
(2 rows)
问题汇总:
1. 如果登陆到数据库中,执行下面语句,发现只有coord的信息,说明并没有创建成功,