gp_pgdatabase

Post date: Jan 20, 2014 2:33:48 AM

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.