Install the extension manager

Install the Hydra package

Add Config and settings

Restart Postgres & create extension

​
Step 1: Install the postgres extension manager “pgxman”

pgxman simplifies deployment and automatically manages correct Hydra versions, build & run dependencies, operating system, and platform architecture.

Curl: curl -sfL https://install.pgx.sh | sh -

Homebrew: brew install pgxman/tap/pgxman

​
Step 2: Install Hydra package:

pgxman install hydra_pg_duckdb

​
Step 3: Add Config file and settings at:

/etc/postgresql/{version}/main/postgresql.conf

In settings add:

shared_preload_libraries = 'pg_duckdb'
duckdb.hydra_token = 'paste token from http://platform.hydra.so/get-started'

Visit http://platform.hydra.so/token to fetch the access token and paste it into the section above.

​

Step 4: Restart Postgres & create extension

restart

sudo service postgresql restart

create extension

create extension pg_duckdb

Installation is now complete!

Next, check out the Quick Start guide to try serverless analytics on Postgres.

​
Additional Resources

We recommend checking out: