Installing Analytics Accelerator v1.3

To use the Postgres Analytics Accelerator (PGAA), you must install the extension on your Postgres instance and enable the background worker for the query engine. See Compatibility for a full list of supported platforms.

Downloading and installing the package

Download the package from the EDB repository:

export EDB_SUBSCRIPTION_TOKEN=<your-token>
export EDB_SUBSCRIPTION_PLAN=<your-subscription-plan>
curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_SUBSCRIPTION_PLAN/setup.deb.sh" | sudo -E bash
sudo apt-get install -y <postgres-distribution>-pgaa

export EDB_SUBSCRIPTION_TOKEN=<your-token>
EDB_SUBSCRIPTION_PLAN=<your-subscription-plan>
curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_SUBSCRIPTION_PLAN/setup.rpm.sh" | sudo -E bash
sudo dnf install -y <postgres-distribution>-pgaa

Where

• $EDB_SUBSCRIPTION_TOKEN is the token you received when you registered for the EDB subscription.
• $EDB_SUBSCRIPTION_PLAN is either standard (for PGE or Community Postgres) or enterprise (for EPAS).
• <postgres-distribution> specifies your Postgres distribution (edb-postgresextended, edb-as, or postgres), and version.

Enabling the extension

To initialize PGAA, you must update your postgresql.conf file. Adding pgaa to shared_preload_libraries allows Postgres to manage the life cycle of the Seafowl query engine as a background worker.

1. Edit postgresql.conf:

   → WrapCopy

   shared_preload_libraries = 'pgaa'
   pgaa.autostart_seafowl = on

2. Restart your Postgres service to load the new library. Once restarted, log in to your Postgres instance and create the PGAA extension:

   → WrapCopy

   CREATE EXTENSION IF NOT EXISTS pgaa CASCADE;

   Using CASCADE ensures that required dependencies, such as the Postgres File System (PGFS), are automatically installed.

Verifying the installation

Confirm that the extension is active using the \dx meta-command. Once installed, you can configure a storage location to grant PGAA access to your data lake, or integrate Postgres with an Iceberg catalog.