posted Jan 19, 2014, 6:33 PM by Sachchida Ojha
gpadmin=# \d gp_pgdatabase
View "pg_catalog.gp_pgdatabase"
Column | Type | Modifiers
dbid | smallint |
isprimary | boolean |
content | smallint |
valid | boolean |
definedprimary | boolean |
View definition:
SELECT l.dbid, l.isprimary, l.content, l.valid, l.definedprimary
FROM gp_pgdatabase() l(dbid smallint, isprimary boolean, content smallint, valid boolean, definedprimary boolean);

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