Installing Analytics Accelerator

Installing Analytics Accelerator#

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 Analytics Accelerator compatibility for a full list of supported platforms.

!!!Note If you are installing PGAA on a WarehousePG cluster, follow the Installing Analytics Accelerator instead, as the installation and configuration process differs from a standard Postgres deployment.

Downloading and installing the package#

Download the package from the EDB repository:

export EDB_SUBSCRIPTION_TOKEN=<your-token>
export EDB_SUBSCRIPTION_PLAN=postgres_distributed
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>
export EDB_SUBSCRIPTION_PLAN=postgres_distributed
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.

  • <postgres-distribution> is the package name prefix for your distribution and version, for example postgresql-16 (community Postgres), edb-as16 (EDB Postgres Advanced Server), or edb-postgresextended-16 (EDB Postgres Extended).

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 and append PGAA and PGFS to the list of shared libraries using a comma separator:

shared_preload_libraries = <other_libraries>,pgaa,pgfs
pgaa.autostart_seafowl = on

  1. Restart your Postgres service to load the new library.

  2. Log in to your Postgres instance. Depending on whether you are working on a new installation or an update, run the appropriate command:

    • For new installations:

CREATE EXTENSION IF NOT EXISTS pgaa CASCADE;

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

- For upgrading an existing installation:

ALTER EXTENSION pgaa UPDATE;

Verifying the installation#

Confirm that the extension is active using the \dx meta-command or by calling the version function:

SELECT pgaa.pgaa_version();

Once installed, you can Creating a storage location to grant PGAA access to your data lake, or integrate Postgres Integrating with Iceberg catalogs .

Contents