Skip to content

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