|
From: admin <ad...@75...> - 2013-10-14 08:02:09
|
Hello, I'm a newbie and tring to evaluate pgxc for a project.
I need to say pgxc is an interesting solution of cluster.
In the evaluation I found some questions, if somebody can answer it I
will be very glad.
Environment:
pgxc 1.1, centos 6 32bit in virtualbox
ServerA:
gtm
coord_01
datanode_01
ServerB:
datanode_02
Question:
a. Is connection secure between coordinator with datanode, or
coordinator with gtm?
I tried if datanode only allow password authentication it will not
accessable from coordinator,
and gtm have no such config like pg_hda.conf
b. What is the warning "Do not have a GTM snapshot available" mean?
c. If gtm_proxy go after gtm, it will direct exit, is it a problem?
Example if I'm going to write a loader, step cannot be
gtm_ctl -Z gtm -D gtm start
gtm_ctl -Z gtm_proxy -D gtm_proxy start
but must be
gtm_ctl -Z gtm -D gtm start
[wait the port use by gtm open]
gtm_ctl -Z gtm_proxy -D gtm_proxy start
d. Check only one node is primary seems have a bug, example:
select * from pgxc_node;
"coord_01";"C";5432;"localhost";f;f;1975432854
"datanode_02";"D";15432;"192.168.8.184";f;f;-1414354208
"datanode_01";"D";15432;"192.168.8.183";t;t;-1746477557
select pgxc_pool_reload();
(success)
alter node datanode_01 with (port=15433);
ERROR: PGXC node datanode_01: two nodes cannot be primary
alter node datanode_01 with (primary=true);
ERROR: PGXC node datanode_01: two nodes cannot be primary
alter node datanode_01 with (primary=false);
(success)
select pgxc_pool_reload();
(success)
select * from pgxc_node;
"coord_01";"C";5432;"localhost";f;f;1975432854
"datanode_02";"D";15432;"192.168.8.184";f;f;-1414354208
"datanode_01";"D";15432;"192.168.8.183";f;t;-1746477557
alter node datanode_01 with (primary=true);
ERROR: PGXC node datanode_01: two nodes cannot be primary
These command all done in the same session open from pgadmin.
e. I cant set primary key to a table if remote node added, is it not
supported yet?
alter table test add primary key (id);
ERROR: Cannot create index whose evaluation cannot be enforced to remote
nodes
f. I cant modify value of sequence, is it not supported yet?
select setval('public.test_01_id_seq', 123, true);
ERROR: GTM error, could not obtain sequence value
g. I found some time field name and its type will exchange,
like "name with type text" some time will trun to "text with type name",
and type "name" is not valid.
I have no reproduction way yet but is it a known bug?
h. I found some time sequence from serial will broken then i can't
insert any data,
select nextval('public.test_01_id_seq');
ERROR:
Status: XX00
I can upload database files if you need.
i. Is there some way to get what nodes are using with the table?
These command can manage nodes with table
alter table tablename add node ...
alter table tablename delete node ...
alter table tablename to node ...
but I dont known what command can list what nodes are using with the table.
j. Is this project ready for production use?
|