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.

Extension	Description	6	7.6
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.	—	✓
pgvector	Provides vector similarity search capabilities for WarehousePG that enable searching, storing, and querying machine-learning-generated embeddings at 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.	✓	✓
user_profile	Provides password quality checking and policy definition for WarehousePG.	✓	✓
Vector Plus	Provides the `ivfplus` index access method for vector similarity search in WarehousePG, built on pgvector.	—	✓
whpg-anonymizer	Provides dynamic data masking and static data anonymization for WarehousePG.	—	✓
whpg-cron	Provides a cron-based job scheduler for running periodic SQL commands directly from WarehousePG.	—	✓
whpg-diskquota	Limits the amount of disk space used by schemas, roles, tablespaces, databases, or the cluster.	✓	✓
whpg_fdw	Provides a foreign data wrapper (FDW) for accessing data stored in a remote WarehousePG cluster.	✓	✓
whpg-partman	Automates the creation, maintenance, and retention of time-based and serial ID-based partition sets.	—	✓
whpg-pgsphere	Provides spherical data types and operators for astronomical data.	—	✓
whpg-q3c	Provides spherical indexing for astronomical catalogues.	—	✓
whpg-utl-raw	Provides Oracle-compatible `UTL_RAW` functions for manipulating the `RAW` binary data type.	✓	✓

Downloading and installing an extension

Install the EDB extension package on each host in your WarehousePG cluster.

From the coordinator, download the package from the EDB repository:

RHEL 8, 9
RHEL 7

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>

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>

<your-token> is the token you received when you registered for the EDB subscription, <major_version> is your WarehousePG version, 6 or 7, and <extension_name> is the name of the extension you want to install.

Create a file all_hosts on your WarehousePG coordinator, listing all hosts in the cluster. For example:
```
cdw
scdw
sdw1
sdw2
sdw3
```
From the coordinator, use the gpsync utility to transfer the package to all hosts in the cluster, then use the gpssh utility to install the package:
- RHEL 8, 9
- RHEL 7
gpsync -f all_hosts <package-name> =:/tmp gpssh -f all_hosts -e 'sudo dnf install -y /tmp/<package-name>'
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.

Upgrading an extension

Upgrade the EDB extension package on each host in your WarehousePG cluster.

From the coordinator, download the new package version from the EDB repository:

RHEL 8, 9
RHEL 7

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>

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>

On your WarehousePG coordinator, use the same all_hosts file you created when you installed the extension, listing all hosts in the cluster.
From the coordinator, use the gpsync utility to transfer the new package to all hosts in the cluster, then use the gpssh utility to upgrade the package:
- RHEL 8, 9
- RHEL 7
gpsync -f all_hosts <package-name> =:/tmp gpssh -f all_hosts -e 'sudo dnf upgrade -y /tmp/<package-name>'
gpsync -f all_hosts <package-name> =:/tmp gpssh -f all_hosts -e 'sudo yum upgrade -y /tmp/<package-name>'
Where <package-name> is the name of the new package file you downloaded.

Once the package is upgraded on every host, follow the extension's own documentation to complete the upgrade, such as updating the extension in each database where it's registered.