PGXC_NODE
PGXC_NODE records information about cluster nodes.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name |
| node_type | "char" | Node type C: CN D: DN |
| node_port | integer | Port ID of the node |
| node_host | name | Host name or IP address of a node. (If a virtual IP address is configured, its value is a virtual IP address.) |
| node_port1 | integer | Port number of a replication node |
| node_host1 | name | Host name or IP address of a replication node. (If a virtual IP address is configured, its value is a virtual IP address.) |
| hostis_primary | Boolean | Whether a switchover occurs between the primary and the standby server on the current node |
| nodeis_primary | Boolean | Whether the current node is preferred to execute non-query operations in the replication table |
| nodeis_preferred | Boolean | Whether the current node is preferred to execute queries in the replication table |
| node_id | integer | Node identifier |
| sctp_port | integer | Specifies the port used by the TCP proxy communication library or SCTP communication library of the primary node to listen to the data channel. |
| control_port | integer | Specifies the port used by the TCP proxy communication library or SCTP communication library of the primary node to listen to the control channel. |
| sctp_port1 | integer | Specifies the port used by the TCP proxy communication library or SCTP communication library of the standby node to listen to the data channel. |
| control_port1 | integer | Specifies the port used by the TCP proxy communication library or SCTP communication library of the standby node to listen to the control channel. |
| nodeis_central | Boolean | Indicates that the current node is the central node. |
Last Article: PGXC_GROUP
Next Article: System Views
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.