Managing a Greenplum System

This section describes basic system administration tasks performed by a Greenplum Database system administrator.

  • Starting and Stopping Greenplum Database
    In a Greenplum Database DBMS, the database server instances (the master and all segments) are started or stopped across all of the hosts in the system in such a way that they can work together as a unified DBMS.
  • Accessing the Database
    This topic describes the various client tools you can use to connect to Greenplum Database, and how to establish a database session.
  • Configuring the Greenplum Database System
    Server configuration parameters affect the behavior of Greenplum Database.
  • Enabling High Availability Features
    The fault tolerance and the high-availability features of Greenplum Database can be configured.
  • Backing Up and Restoring Databases
    The topic describes Greenplum backup and restore features.
  • Expanding a Greenplum System
    To scale up performance and storage capacity, expand your Greenplum system by adding hosts to the array.
  • Migrating Data with Gptransfer
    This topic describes how to use the gptransfer utility to transfer data between databases.
  • Monitoring a Greenplum System
    You can monitor a Greenplum system using a variety of tools included with the system or available as add-ons. SNMP support allows Greenplum to be integrated with popular system management frameworks.
  • Routine System Maintenance Tasks
    To keep a Greenplum Database system running efficiently, the database must be regularly cleared of expired data and the table statistics must be updated so that the query optimizer has accurate information.
  • Recommended Monitoring and Maintenance Tasks
    This section lists monitoring and maintenance activities recommended to ensure high availability and consistent performance of your Greenplum Database cluster.
Parent topic: Greenplum Database Administrator Guide