For RHEL/CentOS and Ubuntu, you can download a Tanzu Greenplum Backup and Restore software distribution as a package for the Greenplum package manager (
gppkg). You can also download and install the software from a 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.
gppkg utility installs the Greenplum Backup and Restore software on all hosts in your Greenplum Database system.
Download the latest Tanzu Greenplum Backup and Restore software distribution for your Greenplum Database version and OS platform from VMware Tanzu Network.
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 -i pivotal_greenplum_backup_restore-<version>-<platform>.gppkg
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 VMware Tanzu Network.
Copy the compressed tarball file to the Greenplum Database master host.
$ scp pivotal_greenplum_backup_restore-<version>.tar.gz gpadmin@mdw:
Log in to the Greenplum Database master host as the gpadmin user.
$ 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.
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 host.
$ 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 hosts.
$ gpssh -f hostfile_gpssh -v -e 'gpbackup --version'
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
$ 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)