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
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 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 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