云数据库 GaussDB-DROP NODE GROUP:示例

时间:2025-01-26 10:48:21

示例

--查询集群DN初始状态。gaussdb=# SELECT node_name, nodeis_preferred FROM pgxc_node WHERE node_type = 'D' ORDER BY 1; node_name | nodeis_preferred-----------+------------------ dn_6001_6002_6003 | f dn_6004_6005_6006 | f dn_6007_6008_6009 | f(3 rows)--创建NODE GROUP,用上一步中查询到的真实节点名称替换dn_6001_6002_6003。gaussdb=# CREATE NODE GROUP test_group WITH ( dn_6001_6002_6003 );--删除NODE GROUP。gaussdb=# DROP NODE GROUP test_group;
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-0604.html