52.65. pgxc_node

The catalog pgxc_node stores information about cluster node information, such as connection information with node port and host, node name, primary and preferred nodes.

Table 52.66. pgxc_node Columns

node_namename Name of cluster node
node_typechar Type of cluster node. It is C for a Coordinator. It is D for a Datanode.
node_portint4 Port number of cluster node
node_hostname Host name or IP number of cluster node
nodeis_primarybool Defines if node is a primary node. Only Datanode can be a primary node.
nodeis_preferredbool Defines if node is a preferred node. Only a Datanode can be a preferred node.
node_idint4 Integer node identifier of node. It is generated when node is created.