Installation Guide

Installation Guide

You can download the Pivotal Greenplum Backup and Restore software distribution as a package for the Greenplum package manager, gppkg, or as a compressed tarball. The gppkg distribution works on platforms that have an RPM package manager. For platforms without RPM support, such as Ubuntu, you will need the compressed tarball.

Note: If you want to use the DD Boost plugin to back up to a Dell EMC Data Domain appliance, after you install the Greenplum Backup and Restore software see Installing pgcrypto in Greenplum Database.

Installing the gppkg Distribution

The gppkg utility installs the Greenplum Backup and Restore software on all hosts in your Greenplum Database system.

  1. Download the latest Pivotal Greenplum Backup and Restore software distribution for your Greenplum Database version and OS platform from Pivotal Network.
  2. Copy the gppkg file you downloaded to the gpadmin user's home directory on the Greenplum Database master host.
    $ scp pivotal_greenplum_backup_restore-<version>.gppkg gpadmin@mdw:
  3. Install the package using the Greenplum Database gppkg utility.
    $ gppkg -i pivotal_greenplum_backup_restore-<version>-<platform>.gppkg

Installing the tarball Distribution

Install the Greenplum Backup and Restore tarball distribution on every host in your Greenplum System, including the master, standby master, and segment hosts.

  1. Download the latest Backup and Restore compressed tarball distribution from Pivotal Network.
  2. Copy the compressed tarball file to the Greenplum Database master host.
    $ scp pivotal_greenplum_backup_restore-<version>.tar.gz gpadmin@mdw:
  3. Log in to the Greenplum Database master host as the gpadmin user.
    $ ssh gpadmin@mdw
  4. Copy the Backup and Restore compressed tarball to the Greenplum Database installation directory on the master, standby master, and every segment host.
    Note: The hostfile_gpssh file contains a list of all Greenplum hosts, including the master and standby master hosts.
    $ gpscp -v -f hostfile_gpssh pivotal_greenplum_backup_restore-<version>.tar.gz =:/$GPHOME
  5. Unpack the tarball in the $GPHOME directory on every Greenplum host.
    $ gpssh -f hostfile_gpssh -v -e 'cd $GPHOME; tar -xzvf pivotal_greenplum_backup_restore-<version>.tar.gz'
  6. Verify that the Backup and Restore version is installed on all of the hosts.
    $ gpssh -f hostfile_gpssh -v -e 'gpbackup --version'

Installing pgcrypto in Greenplum Database

If you are using the DD Boost plugin to back up to a Dell EMC Data Domain appliance and you want to secure Data Domain passwords in the DD Boost configuration file, you must install the pgcrypto extension in the postgres database.

The method for installing pgcrypto differs for each Greenplum Database major version.

You can verify that the pgcrypto functions are installed in the postgres database by listing a pgcrypto function, for example the digest() function.

$ psql postgres
postgres=# \df digest
                         List of functions
 Schema |  Name  | Result data type | Argument data types |  Type
--------+--------+------------------+---------------------+--------
 public | digest | bytea            | bytea, text         | normal
 public | digest | bytea            | text, text          | normal
(2 rows)