gp_configuration_history

gp_configuration_history

The gp_configuration_history table contains information about system changes related to fault detection and recovery operations. The fts_probe process logs data to this table, as do certain related management utilities such as gpcheck, gprecoverseg, and gpinitsystem. For example, when you add a new segment and mirror segment to the system, records for these events are logged to gp_configuration_history.

This table is populated only on the master. This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.

Table 1. pg_catalog.gp_configuration_history
column type references description
time timestamp with time zone   Timestamp for the event recorded.
dbid smallint gp_segment _configuration.dbid System-assigned ID. The unique identifier of a segment (or master) instance.
desc text   Text description of the event.

For information about gpcheck, gprecoverseg, and gpinitsystem, see the Greenplum Database Utility Guide.