云数据库 GaussDB-ALTER NODE:语法格式

时间:2023-11-01 16:22:50

语法格式

 1 2 3 4 5 6 7 8 910111213141516
ALTER NODE nodename WITH  (    [ TYPE = nodetype,]    [ HOST = hostname,]    [ PORT = portnum,]    [ HOST1 = 'hostname',]    [ PORT1 = portnum,]    [ HOSTPRIMARY [ = boolean ],]    [ PRIMARY [ = boolean ],]    [ PREFERRED [ = boolean ],]    [ SCTP_PORT = portnum,]    [ CONTROL_PORT = portnum,]    [ SCTP_PORT1 = portnum,]    [ CONTROL_PORT1 = portnum, ]    [ NODEIS_CENTRAL [ = boolean ]]  );

PORT选项指定的端口号为节点间内部通信绑定的端口号,不同于外部客户端连接节点的端口号,可通过pgxc_node表查询。

support.huaweicloud.com/distributed-devg-v2-opengauss/gaussdb-v5r2c10-0532.html