​
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: 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;