Performing Greenplum Backups

You can perform backup of one or more Greenplum databases.

You can perform a full or incremental backup of the Greenplum databases.

An incremental backup contains the changed data from the last successful backup. Incremental backups use less media and resources than full backups.

Note

Greenplum includes all tables that use the append-optimized storage model (a heap table) in an incremental backup. To take advantage of the space savings of an incremental backup, use append-optimized tables.

For information on Greenplum incremental backups, go to the Pivotal Knowledge Base, incremental architecture backup.

The Commvault software uses the gpcrondump command with the following options:

  • The name of the databases that are included in the backup (-x)

  • The string to prepend to the database. The string is set to 'cv' (-prefix)

  • The do not prompt option (-a)

  • The bypass space check option (-b)

  • The backup timestamp(-K)

  • The log file directory (-l)

  • The backup directory (-u)

  • The option to not use compression (-z)

For a complete description of the options, go to the Pivotal website, gpcrondump.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Greenplum > instance.

  2. Right-click the subclient and click Backup.

    The Backup Options dialog box is displayed.

  3. Select the backup type and job initiation:

    1. In the Select Backup Type area, choose your backup type:

      • To perform a full backup, select Full.

      • To perform an incremental backup, select Incremental.

    2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

  4. Optional: To set advanced backup options, click Advanced.

  5. Click OK.

You can track the progress of the job from the Job Controller. When the backup has completed, the Job Controller displays Completed.

After your backup job is complete, you can view the backup job history. For more information, see Job History.

You can see the configuration that the software used for the backup. For more information, see Viewing the Greenplum Database System Configuration Used in the Last Backup.

Loading...