gp_pgdatabase_invalid

The gp_toolkit.gp_pgdatabase_invalid view shows information about segments that are marked as down in the system catalog. This view is accessible to all users.

Column Description

Column	Description
pgdbidbid	The segment `dbid`. Every segment has a unique `dbid`
pgdbiisprimary	Whether the segment is currently acting as the primary (active) segment (`t` or `f`)
pgdbicontent	The content ID of this segment. A primary and mirror will have the same content ID
pgdbivalid	Whether this segment is up and valid (`t` or `f`)
pgdbidefinedprimary	Whether this segment was assigned the role of primary at system initialization (`t` or `f`)

pgdbidbid

The segment dbid. Every segment has a unique dbid

pgdbiisprimary

Whether the segment is currently acting as the primary (active) segment (t or f)

pgdbicontent

The content ID of this segment. A primary and mirror will have the same content ID

pgdbivalid

Whether this segment is up and valid (t or f)

pgdbidefinedprimary

Whether this segment was assigned the role of primary at system initialization (t or f)

gp_param_settings_seg_value_diffs

gp_resgroup_config