Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Install

Builds are published weekly for the stable DuckDB release and recent 2.0 dev builds (linux_amd64). Each is a GitHub pre-release, duckdb-<version>, and https://pgvfs.adonm.dev serves them as a DuckDB extension repository, so DuckDB fetches the build that matches its own version:

-- start DuckDB with allow_unsigned_extensions = true (CLI: duckdb -unsigned)
INSTALL pgvfs FROM 'https://pgvfs.adonm.dev';
LOAD pgvfs;

-- one secret for the DuckLake catalog and the pgvfs data
CREATE SECRET (TYPE postgres, HOST 'db', USER 'lake', PASSWORD '...', DATABASE 'lake');
ATTACH 'ducklake:postgres:' AS lake (DATA_PATH 'pgvfs://lake/');

In Python: duckdb.connect(config={"allow_unsigned_extensions": "true"}). The builds and their matching wheels are listed at https://pgvfs.adonm.dev/install.html. You can also install one straight from its release: INSTALL 'https://github.com/adonm/pgvfs/releases/download/duckdb-v1.5.6/pgvfs.duckdb_extension'.

Paths are pgvfs://<volume>/<path>. A volume ([a-z0-9][a-z0-9._-]{0,62}) is a namespace, so one database can hold several lakes.

Published builds

DuckDB versionPython wheelBuiltCommitDirect install
v1.5.6duckdb==1.5.62026-09-295924edb441fefile
v2.0.0-alpha43385duckdb==2.0.0.dev26092507152026-09-295924edb441fefile