DROP NODE

DROP NODE — drop a cluster node

Synopsis

DROP NODE nodename

Description

DROP NODE is new SQL command specific to Postgres-XL that deletes cluster node information in catalog pgxc_node.

Node connection that has been deleted does not guarantee that connection information cached in pooler is updated accordingly.

DROP NODE only runs on the local node where it is launched.

Parameters

nodename

The name of the selected cluster node.

Examples

Drop a cluster node.

DROP NODE cluster_node;

Compatibility

DROP NODE does not conform to the SQL standards, it is a Postgres-XL specific command.