Postgres-XC 1.1 Documentation | ||||
---|---|---|---|---|
Prev | Up | Chapter 47. System Catalogs | Next |
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 47-54. pgxc_node Columns
Name | Type | References | Description |
---|---|---|---|
node_name | name | Name of cluster node | |
node_type | char | Type of cluster node. It is C for a Coordinator. It is D for a Datanode. | |
node_port | int4 | Port number of cluster node | |
node_host | name | Host name or IP number of cluster node | |
nodeis_primary | bool | Defines if node is a primary node. Only Datanode can be a primary node. | |
nodeis_preferred | bool | Defines if node is a preferred node. Only a Datanode can be a preferred node. | |
node_id | int4 | Integer node identifier of node. It is generated when node is created. |