Installation Guide

Installation Guide

Follow these steps to download and install the Greenplum Backup and Restore software:

  1. Log in to the Greenplum Database master host as the gpadmin user.
  2. Download the latest Pivotal Greenplum Backup and Restore software distribution for your Greenplum Database version and OS platform from Pivotal Network.
  3. Install the distribution using the Greenplum Database gppkg utility.
    $ gppkg -i pivotal_greenplum_backup_restore-<version>-<platform>.gppkg

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.

Greenplum Database 4.3.x

  1. Download the pgcrypto extension from Pivotal Network. Choose your Greenplum Database 4.3 release number and then download the PGCrypto Extension for your platform from the Greenplum Encryption folder.
  2. Copy the downloaded file to your Greenplum Database master host. Example:
    $ scp pgcrypto-ossv1.1_pv1.3.gpdb4.3orca-rhel5-x86_64.gppkg gpadmin@mdw:~
  3. Log in to the master host as gpadmin and install the pgcrypto gppkg file:
    $ gppkg -i pgcrypto-ossv1.1_pv1.3.gpdb4.3orca-rhel5-x86_64.gppkg
  4. Run the pgcrypto SQL script to install the pgcrypto functions in the postgres database:
    $ psql -d postgres -f $GPHOME/share/postgresql/contrib/pgcrypto.sql

Greenplum Database 5.x

Pgcrypto is installed with Greenplum Database 5.

To install the pgcrypto functions in the postgres database, log in to the master host as gpadmin and run the pgcrypto SQL script:

$ psql -d postgres -f $GPHOME/share/postgresql/contrib/pgcrypto.sql

Greenplum Database 6.x

Pgcrypto is installed as a Greenplum extension with Greenplum Database 6. To install the pgcrypto functions in the postgres database, log in to the master host as gpadmin and execute the CREATE EXTENSION command in the postgres database:

$ psql -d postgres -c "CREATE EXTENSION pgcrypto"