Installing extensions v7.5

Extensions require a separate package install before you can enable them with CREATE EXTENSION. Depending on the extension, you may need to install the package on all hosts or only on the coordinator. See the individual extension's reference page for details.

Once you've installed the package, activate the extension in each target database:

psql -d <database_name> -c 'CREATE EXTENSION <extension_name>;'

Downloading and installing an EDB-provided extension

You must install the 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.