Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PGXC_NODE

PGXC_NODE

Updated at: Jul 15, 2020 GMT+08:00

PGXC_NODE records information about cluster nodes.

Table 1 PGXC_NODE columns

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel