EDB provided modules

EDB-provided modules deliver a suite of enterprise-grade extensions specifically engineered to enhance the security, performance, and manageability of your WarehousePG cluster. Backed by 24x7 expert support, these modules ensure your environment meets the rigorous demands of business-critical, petabyte-scale data warehousing.

EDB provides the following modules:

• pgAudit - Provides detailed session and object audit logging for WarehousePG.
• user_profile - Provides password quality checking and policy definition for WarehousePG.
• whpg_fdw - Provides a foreign data wrapper (FDW) for accessing data stored in a remote WarehousePG cluster.

Downloading and installing an 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.