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 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.
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 gprecoverseg and gpinitsystem, see the Greenplum Database Utility Guide.