About Management and Monitoring Utilities

About Management and Monitoring Utilities

Greenplum Database provides standard command-line utilities for performing common monitoring and administration tasks.

Greenplum command-line utilities are located in the $GPHOME/bin directory and are executed on the master host. Greenplum provides utilities for the following administration tasks:

  • Installing Greenplum Database on an array
  • Initializing a Greenplum Database System
  • Starting and stopping Greenplum Database
  • Adding or removing a host
  • Expanding the array and redistributing tables among new segments
  • Managing recovery for failed segment instances
  • Managing failover and recovery for a failed master instance
  • Backing up and restoring a database (in parallel)
  • Loading data in parallel
  • Transferring data between Greenplum databases
  • System state reporting

Greenplum Database includes a gpperfmon_install management utility, which creates the gpperfmon database and enables the data collection agents. Users can query the gpperfmon database to see query and system metrics.