Managing a Greenplum System

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

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 Compression
You can configure Greenplum Database to use data compression with some database features and with some utilities.
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 with gpcopy
You can use the gpcopy utility to transfer data between databases in different Greenplum Database clusters.
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.
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