ducklake-test
par posthog
Lancer duckgres avec DuckLake (stockage basé sur S3 avec métadonnées PostgreSQL) pour les tests locaux. Utiliser lors des tests de duckgres contre DuckLake ou de la reproduction de Fivetran…
npx skills add https://github.com/posthog/duckgres --skill ducklake-testStart duckgres with DuckLake configuration:
-
Start dependencies (PostgreSQL metadata store + MinIO object storage):
docker-compose up -d -
Kill any existing duckgres process:
pkill -f duckgres || true -
Ensure config file exists at
duckgres_local_test.yaml:host: "0.0.0.0" port: 35437 data_dir: "./data" users: postgres: "postgres" extensions: - ducklake ducklake: metadata_store: "postgres:host=localhost port=5433 user=ducklake password=ducklake dbname=ducklake" object_store: "s3://ducklake/data/" s3_provider: "config" s3_endpoint: "localhost:9000" s3_access_key: "minioadmin" s3_secret_key: "minioadmin" s3_region: "us-east-1" s3_use_ssl: false s3_url_style: "path" -
Build and run duckgres:
go build -o duckgres . && ./duckgres --config duckgres_local_test.yaml -
Connect with psql (in another terminal):
PGPASSWORD=postgres psql "host=127.0.0.1 port=35437 user=postgres sslmode=require"
To cleanup: pkill -f duckgres && docker-compose down