Extensions v7.5

These extensions require a separate package install on each host in your WarehousePG cluster before you can enable them.

• diskquota - Allows WarehousePG administrators to limit the amount of disk space used by schemas, roles, or tablespaces in a database.
• MADlib - Provides machine learning routines for structured and unstructured data.
• PGAA - Enables distributed analytical queries against object storage directly from WarehousePG, with support for Parquet, Delta Lake, and Iceberg formats.
• pgAudit - Provides detailed session and object audit logging for WarehousePG.
• PGFS - Provides the storage layer for object storage connectivity, including credential management for S3, GCS, and Azure. Required dependency of PGAA.
• pgsphere - Provides spherical data types and operators for astronomical data.
• pgvector - Provides vector similarity search capabilities for WarehousePG that enable searching, storing, and querying machine language-generated embeddings at large scale.
• PostGIS - Provides spatial and geographic data types and functions for WarehousePG.
• postgresql-hll - Provides native HyperLogLog data types and relation functions, operators, and aggregates.
• q3c - Provides spherical indexing for astronomical catalogues.
• user_profile - Provides password quality checking and policy definition for WarehousePG.
• whpg-anonymizer - Provides dynamic data masking and static data anonymization for WarehousePG.
• whpg_fdw - Provides a foreign data wrapper (FDW) for accessing data stored in a remote WarehousePG cluster.
• whpg-utl-raw - Provides Oracle-compatible UTL_RAW functions for manipulating the RAW binary data type.

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.