ducklake-test
bởi posthog
Khởi động duckgres với DuckLake (bộ nhớ hỗ trợ S3 với siêu dữ liệu PostgreSQL) để kiểm tra cục bộ. Sử dụng khi kiểm tra duckgres với DuckLake hoặc tái tạo 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