| Postgres-XC 1.0.3 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 45. System Catalogs | Fast Forward | 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 45-52. 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. |