SKILL.md
Start duckgres with DuckLake configuration:
- Start dependencies (PostgreSQL metadata store + MinIO object storage):
``bash docker-compose up -d ``
- Kill any existing duckgres process:
``bash pkill -f duckgres || true ``
- Ensure config file exists at
duckgreslocaltest.yaml:
``yaml host: "0.0.0.0" port: 35437 datadir: "./data" users: postgres: "postgres" extensions: - ducklake ducklake: metadatastore: "postgres:host=localhost port=5433 user=ducklake password=ducklake dbname=ducklake" objectstore: "s3://ducklake/data/" s3provider: "config" s3endpoint: "localhost:9000" s3accesskey: "minioadmin" s3secretkey: "minioadmin" s3region: "us-east-1" s3usessl: false s3urlstyle: "path" ``
- Build and run duckgres:
``bash go build -o duckgres . && ./duckgres --config duckgreslocaltest.yaml ``
- Connect with psql (in another terminal):
``bash PGPASSWORD=postgres psql "host=127.0.0.1 port=35437 user=postgres sslmode=require" ``
To cleanup: pkill -f duckgres && docker-compose down