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.

Group2082(3) Pn

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: