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:
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_hostswhich 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
gpsyncutility on WarehousePG 7, or thegpscputility on WarehousePG 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 examplewhpg-backup-1.33.1-WHPG-2.el8.x86_64.rpm.From the coordinator, use the
gpsshutility to install the package on all hosts: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
gpbackupandgprestoreversions: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.
Upgrading to 1.34.1
Review the following before you upgrade to 1.34.1 from an earlier version:
- On WarehousePG 7.4 and later, backups taken with 1.34.0 or earlier contain no data for coordinator-only tables, including incremental backups. After upgrading, take a new full backup of any database that has them.
- If you use a custom storage plugin and have coordinator-only tables, make sure the plugin is installed on the coordinator and accepts
backup_dataandrestore_datacalls with content-1. Backing up or restoring a coordinator-only table now calls the plugin on the coordinator, once per table. The S3 storage plugin is not affected. - Scripts that pass an empty
--plugin-config, for example--plugin-config "$CFG"withCFGunset, used to run without a plugin and now fail. - Backups taken with an empty
--plugin-configon earlier versions are on the segment hosts' local disks, not on plugin storage. Restore them withgprestorewithout--plugin-config, or delete them to free the disk space.
On the coordinator, download the new package version from the EDB repository:
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
From the coordinator, transfer the package to all hosts in the cluster. Use the
gpsyncutility on WarehousePG 7, or thegpscputility on WarehousePG 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 new WarehousePG Backup package file you downloaded, for examplewhpg-backup-1.34.0-WHPG-1.el8.x86_64.rpm.From the coordinator, use the
gpsshutility to upgrade the package on all hosts:gpssh -f all_hosts -e 'sudo dnf upgrade -y /tmp/<whpg-backup-package-name>'
gpssh -f all_hosts -e 'sudo yum upgrade -y /tmp/<whpg-backup-package-name>'
Verify the upgrade by checking the
gpbackupandgprestoreversions:gpbackup --version gprestore --version