Managing a Greenplum System

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

This section contains the following topics:

• About the Greenplum Database Release Version Number
  Greenplum Database version numbers and they way they change identify what has been modified from one Greenplum Database release to the next.

• 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 and Data Consistency Features
  The fault tolerance and the high-availability features of Greenplum Database can be configured.

• Backing Up and Restoring Databases
  This topic describes how to use Greenplum backup and restore features.

• Expanding a Greenplum System
  To scale up performance and storage capacity, expand your Greenplum Database system by adding hosts to the system. In general, adding nodes to a Greenplum cluster achieves a linear scaling of performance and storage capacity.

• Migrating Data

• Monitoring a Greenplum System
  You can monitor a Greenplum Database 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