15670430创建于 2020年12月28日历史提交
--test create node group
create user testdb_llt password 'gauss@123';
set role testdb_llt password 'gauss@123';
Create node group test_group with(datanode1);
ERROR:  must be system admin or createdb role to create cluster node groups
reset role;
Create node group group1  with(datanode1);
ERROR:  PGXC Group group1: group already defined
Create node group group22  with(datanode100);
ERROR:  PGXC Node datanode100: object not defined
Create node group group22  with(coordinator1);
ERROR:  PGXC node coordinator1: only Datanodes can be group members
Create node group group22  with(datanode1);
drop node group group1;
ERROR:  cannot drop 'group1' because other objects depend on it
Create node group group1 with(datanode1);
ERROR:  PGXC Group group1: group already defined
 
Create node group group2 with(datanode1,datanode2);
drop node group group22;
drop node group group2;
CREATE NODE GROUP group1 WITH (datanode1,datanode2,datanode3,datanode4,datanode5,datanode6,datanode7,datanode8,datanode9,datanode10,datanode11,datanode12);
ERROR:  PGXC Group group1: group already defined
set role testdb_llt password 'gauss@123';
drop node group group1;
ERROR:  must have sysadmin or createdb or drop privilege to remove cluster node groups
reset role;
drop node group group100;
ERROR:  PGXC Group group100: group not defined
drop user testdb_llt;
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1  -A 0 -b -C port -E -i -l -N 10 -h 127.0.0.1  -p 1234 -P 1234  -t pa
[BACKEND] FATAL:  gaussdb: invalid command-line argument: -t
[BACKEND] HINT:  Try "gaussdb --help" for more information.
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -S 64 -s -T  -f s -e NULL  -t pa 
[BACKEND] FATAL:  gaussdb: invalid command-line argument: -t
[BACKEND] HINT:  Try "gaussdb --help" for more information.
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -d 1 -n -W 60  -t pa -r NULL -K NULL
illegal option -- K
[BACKEND] FATAL:  gaussdb: invalid command-line argument: -K
[BACKEND] HINT:  Try "gaussdb --help" for more information.
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -k NULL -v
option requires an argument -- v
[BACKEND] FATAL:  gaussdb: invalid command-line argument: -v
[BACKEND] HINT:  Try "gaussdb --help" for more information.
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -o NULL
[BACKEND] FATAL:  gaussdb: invalid command-line argument: NULL
[BACKEND] HINT:  Try "gaussdb --help" for more information.
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -B 64 
[BACKEND] FATAL:  unrecognized configuration parameter "shared_buffers_default"
\! @abs_bindir@/gaussdb --single  --coordinator -D @cndata@/coordinator1   -c port
[BACKEND] FATAL:  -c port requires a value
\! @abs_bindir@/gaussdb --single  --datanode -D @cndata@/datanode1  -K
illegal option -- K
[BACKEND] FATAL:  gaussdb: invalid command-line argument: -K
[BACKEND] HINT:  Try "gaussdb --help" for more information.