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:

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

    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:

    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:

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

    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_data and restore_data calls 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" with CFG unset, used to run without a plugin and now fail.
  • Backups taken with an empty --plugin-config on earlier versions are on the segment hosts' local disks, not on plugin storage. Restore them with gprestore without --plugin-config, or delete them to free the disk space.
  1. On the coordinator, download the new package version from the EDB repository:

  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:

    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:

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

    gpbackup --version
    gprestore --version

Could this page be better? Report a problem or suggest an addition!