45.51. pgxc_node

Note: The following description applies only to Postgres-XC

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 45-52. pgxc_node Columns

NameTypeReferencesDescription
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.