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 the 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 coordinator 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.
• Configuring Proxies for the Greenplum Interconnect
  You can configure a Greenplum system to use proxies for interconnect communication to reduce the use of connections and ports during query processing.
• 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.
• Monitoring Long-Running Operations
  You can monitor, at run time, the progress of certain SQL and utility commands.
• 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