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.
Installing the gppkg Distribution
The gppkg utility installs the Greenplum Backup and Restore software on all hosts in your Greenplum Database system.
- Download the latest Pivotal Greenplum Backup and Restore software distribution for your Greenplum Database version and OS platform from Pivotal Network.
- 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:
- 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.
- Download the latest Backup and Restore compressed tarball distribution from Pivotal Network.
- Copy the compressed tarball file to the Greenplum Database master
$ scp pivotal_greenplum_backup_restore-<version>.tar.gz gpadmin@mdw:
- Log in to the Greenplum Database master host as the gpadmin
$ ssh gpadmin@mdw
- 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
- Unpack the tarball in the $GPHOME directory on every Greenplum
$ gpssh -f hostfile_gpssh -v -e 'cd $GPHOME; tar -xzvf pivotal_greenplum_backup_restore-<version>.tar.gz'
- Verify that the Backup and Restore version is installed on all of the
$ 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.
- Greenplum Database 4.3.x - See Installing Greenplum Database Extensions in the Greenplum Database Installation Guide.
- Greenplum Database 5.x - See Installing Optional Extensions in the Greenplum Database Installation Guide.
- Greenplum Database 6.x - See Installing Additional Supplied Modules in the Greenplum Database Installation Guide.
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)