Local Development

​

Run with Docker

Docker images are available on Dockerhub and are based on the official Postgres image. Use of this image is the same as the Postgres image. For example, you can run the image directly:

docker run -d -e POSTGRES_PASSWORD=duckdb pgduckdb/pgduckdb:16-main

Or you can use docker compose:

git clone https://github.com/duckdb/pg_duckdb
cd pg_duckdb
docker compose up -d

Once started, connect to the database using psql:

psql postgres://postgres:duckdb@127.0.0.1:5432/postgres
# Or if using docker compose
docker compose exec db psql

For more information, see the Docker README.

​

Compile from Source

To build pg_duckdb, you need:

• Postgres 15-17
• Ubuntu 22.04-24.04 or MacOS
• Standard set of build tools for building Postgres extensions
• Build tools that are required to build DuckDB

To build and install, run:

make install

Add pg_duckdb to the shared_preload_libraries in your postgresql.conf file:

shared_preload_libraries = 'pg_duckdb'

Next, create the pg_duckdb extension:

CREATE EXTENSION pg_duckdb;