Installing and upgrading WarehousePG Backup and Restore

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

Downloading and installing the utility

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

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

   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

   → WrapCopy

   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

2. On the coordinator, create a file all_hosts which lists all hosts in the WHPG cluster. For example:

   → WrapCopy

   cdw
   scdw
   sdw1
   sdw2
   sdw3

3. 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

   → WrapCopy

   gpsync -f all_hosts <whpg-backup-package-name> =:/tmp

   → WrapCopy

   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.

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

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

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

   → WrapCopy

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

5. Verify the installation by checking the gpbackup and gprestore versions:

   → WrapCopy

   gpbackup --version
   gprestore --version

Upgrading

Upgrade whpg-backup on every host in your cluster. gpbackup and gprestore don't run as a service and don't persist configuration between runs, so there's no data or configuration migration to complete. Avoid upgrading while a backup or restore is in progress.

1. On the coordinator, download the new package version from the EDB repository:

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

   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

   → WrapCopy

   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

2. 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

   → WrapCopy

   gpsync -f all_hosts <whpg-backup-package-name> =:/tmp

   → WrapCopy

   gpscp -f all_hosts <whpg-backup-package-name> =:/tmp

   Where <whpg-backup-package-name> is the name of the new WarehousePG Backup package file you downloaded, for example whpg-backup-1.34.0-WHPG-1.el8.x86_64.rpm.

3. From the coordinator, use the gpssh utility to upgrade the package on all hosts:

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

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

   → WrapCopy

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

4. Verify the upgrade by checking the gpbackup and gprestore versions:

   → WrapCopy

   gpbackup --version
   gprestore --version