gp_segment_configuration

The gp_segment_configuration table contains information about master, standby and segment configuration.

The HAWQ fault tolerance service (FTS) automatically detects the status of individual segments and marks the status of each segment in this table. If a segment is marked as DOWN, the corresponding reason is recorded in the gp_configuration_history table. See Understanding the Fault Tolerance Service for a description of the fault tolerance service.

Table 1. pg_catalog.gp_segment_configuration

columntypereferencesdescription
registration_orderinteger When HAWQ starts, the master and each segment starts itself separately. This column indicates the order in which a segment node registers itself to master node. The registration_order for segments starts from 1. Master’s registration_order is 0. Standby’s registration_order is -1.
rolechar The role that a node is currently running as. Values are p (segment), m(master) or s(standby).
statuschar The fault status of a segment. Values are u (up) or d (down).
portinteger The TCP port the database server listener process is using.
hostnametext The hostname of a segment host.
addresstext The hostname used to access a particular segment on a segment host.
failed_tmpdir_numinteger The number of failed temporary directories on the segment. User- configured temporary directories may fail on segments due to disk errors. This information is reported to the master.
failed_tmpdirtext A list of failed temporary directories on the segment. Multiple failed temporary directories are separated by commas.