O'Reilly logo

Getting Started with Greenplum for Big Data Analytics by Sunila Gollapudi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Greenplum Database management

In this section, we will learn about a few in-built tools that help perform some Greenplum administration tasks as listed below:

  • Starting and stopping Greenplum Database
  • Adding new segment servers
  • Loading data in parallel
  • Parallel backup and restoring
  • Managing recovery of failed segments, and so on

The following screenshot shows an object browser window in Greenplum's pgAdminIII, a client tool to manage database elements:

Greenplum Database management

The next screenshot shows the query builder view of pgAdminIII, developers can use this interface to graphically build queries:

The following interface helps monitor the master and segment server status:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required