|
From: Ying He <yin...@ya...> - 2014-01-14 22:13:07
|
hi, I start to use pgxc_ctl and encounter a few issues. I am using the latest pgxc tar and contrib for pgxc_ctl. The test setup is as follows: host1 has gtm master host2 has gtm slave host3 has gtm_proxy1, coordinator1, datanode1 host4 has gtm_proxy2, coordinator2, datanode2 steps: 1. create pgxc_ctl.conf 2. pgxc_ctl init all 3. pgxc_ctl Psql - coord1 CREATE NODE coord2 WITH (TYPE = 'coordinator', HOST = 'host2', PORT = xxxx); CREATE NODE datanode1 WITH (TYPE = 'datanode', HOST = 'host1', PORT = xxxx); CREATE NODE datanode2 WITH (TYPE = 'datanode', HOST = 'host2', PORT = xxxx); pgxc_ctl Psql - coord2 CREATE NODE coord1 WITH (TYPE = 'coordinator', HOST = 'host1', PORT = xxxx); CREATE NODE datanode1 WITH (TYPE = 'datanode', HOST = 'host1', PORT = xxxx); CREATE NODE datanode2 WITH (TYPE = 'datanode', HOST = 'host2', PORT = xxxx); 4. Then it works with the following simple test. both coordinator returns the same data and we are able to write. create table t2 (a int) distribute by replication; insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12), (13),(14); Issues: 1. -m fast is not recognized: |