gp_pgdatabase

The gp_pgdatabase view shows status information about the Greengage DB segment instances and whether they are acting as the mirror or the primary. This view is used internally by the Greengage DB fault detection and recovery utilities to determine failed segments.

Column Type References Description

Column	Type	References	Description
dbid	smallint	gp_segment_configuration.dbid	System-assigned ID. The unique identifier of a segment (or master) instance
isprimary	boolean	gp_segment_configuration.role	Whether or not this instance is active. Is it currently acting as the primary segment (as opposed to the mirror)
content	smallint	gp_segment_configuration.content	The ID for the portion of data on an instance. A primary segment instance and its mirror will have the same content ID. For a segment the value is from `0` to `N-1`, where `N` is the number of segments in a cluster. For the master, the value is `-1`
valid	boolean	gp_segment_configuration.mode	Whether or not this instance is up and the mode is either `s` (synchronized) or `n` (not in sync)
definedprimary	boolean	gp_segment_configuration.preferred_role	Whether or not this instance was defined as the primary (as opposed to the mirror) at the time the system was initialized

dbid

smallint

gp_segment_configuration.dbid

System-assigned ID. The unique identifier of a segment (or master) instance

isprimary

boolean

gp_segment_configuration.role

Whether or not this instance is active. Is it currently acting as the primary segment (as opposed to the mirror)

content

smallint

gp_segment_configuration.content

The ID for the portion of data on an instance. A primary segment instance and its mirror will have the same content ID.

For a segment the value is from 0 to N-1, where N is the number of segments in a cluster.

For the master, the value is -1

valid

boolean

gp_segment_configuration.mode

Whether or not this instance is up and the mode is either s (synchronized) or n (not in sync)

definedprimary

boolean

gp_segment_configuration.preferred_role

Whether or not this instance was defined as the primary (as opposed to the mirror) at the time the system was initialized

gp_endpoints

gp_segment_endpoints