Installing WarehousePG Backup and Restore

Install whpg-backup on all hosts in your WarehousePG cluster.

Downloading and installing the utility

On the coordinator, download the package from the EDB repository:

RHEL 8, 9
RHEL 7

export EDB_SUBSCRIPTION_TOKEN=<your-token>
export EDB_REPO=gpsupp
curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_REPO/setup.rpm.sh" | sudo -E bash
sudo dnf download whpg-backup

export EDB_SUBSCRIPTION_TOKEN=<your-token>
export EDB_REPO=gpsupp
curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_REPO/setup.rpm.sh" | sudo -E bash
sudo yumdownloader whpg-backup

On the coordinator, create a file all_hosts which lists all hosts in the WHPG cluster. For example:
```
cdw
scdw
sdw1
sdw2
sdw3
```
From the coordinator, transfer the package to all hosts in the cluster. Use the gpsync utility on WarehousePG 7, or the gpscp utility on WarehousePG 6:
- WHPG 7
- WHPG 6
gpsync -f all_hosts <whpg-backup-package-name> =:/tmp
gpscp -f all_hosts <whpg-backup-package-name> =:/tmp
Where <whpg-backup-package-name> is the name of the WarehousePG Backup package file you downloaded, for example whpg-backup-1.33.1-WHPG-2.el8.x86_64.rpm.

From the coordinator, use the gpssh utility to install the package on all hosts:

RHEL 8, 9
RHEL 7

gpssh -f all_hosts -e 'sudo dnf install -y /tmp/<whpg-backup-package-name>'

gpssh -f all_hosts -e 'sudo yum install -y /tmp/<whpg-backup-package-name>'

Verify the installation by checking the gpbackup and gprestore versions:
```
gpbackup --version
gprestore --version
```