Additional extensions

These extensions require a separate package install on each host in your WarehousePG cluster before you can enable them, and availability varies by version.

Downloading and installing an extension

You must install the EDB extension on each host in your WarehousePG cluster.

1. From 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 edb-whpg<major_version>-<extension_name>

   → 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 edb-whpg<major_version>-<extension_name>

   Where:

   • <your-token> is the token you received when you registered for the EDB subscription.
   • <major_version> is your WHPG version (6 or 7).
   • <extension_name> is the name of the extension you want to install.

2. Create a file all_hosts on your WHPG coordinator, which lists all hosts in the WHPG cluster. For example:

   → WrapCopy

   cdw
   scdw
   sdw1
   sdw2
   sdw3

3. From the coordinator, use the gpsync utility to transfer the package to all hosts in the cluster and then use the gpssh utility to install the package:

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

   gpsync -f all_hosts <package-name> =:/tmp
   gpssh -f all_hosts -e 'sudo dnf install -y /tmp/<package-name>'

   → WrapCopy

   gpsync -f all_hosts <package-name> =:/tmp
   gpssh -f all_hosts -e 'sudo yum install -y /tmp/<package-name>'

   Where <package-name> is the name of the package file you downloaded.