When enabling file_persistence: true in standalone mode, every connection fails immediately after authentication
with:
Catalog Error: SET schema: No catalog + schema named "memory" found.
The file-backed DuckDB database is opened successfully (Opening file-backed DuckDB. path="/data/duckgres/test.duckdb?allow_unsigned_extensions=true"), extensions load, but the session setup
crashes when trying to switch to the memory catalog.
Steps to Reproduce
- Configure
duckgres.yaml:
host: "0.0.0.0"
port: 5432
data_dir: "/data/duckgres"
file_persistence: true
tls:
cert: "/certs/server.crt"
key: "/certs/server.key"
extensions:
- parquet
- httpfs
users:
test: "test"
- Run duckgres in standalone mode (default)
- Connect with psql:
psql "host=localhost user=test dbname=test sslmode=require"
Test Setup
- Image: ghcr.io/posthog/duckgres:latest
- Version: build-c6f9f04756b68cd4100b65374f2dff1b0f37657c
- Mode: standalone (default)
- DuckDB extensions: parquet, httpfs
- Duckgres is running in a swarm cluster
When enabling
file_persistence: truein standalone mode, every connection fails immediately after authenticationwith:
Catalog Error: SET schema: No catalog + schema named "memory" found.The file-backed DuckDB database is opened successfully (
Opening file-backed DuckDB. path="/data/duckgres/test.duckdb?allow_unsigned_extensions=true"), extensions load, but the session setupcrashes when trying to switch to the
memorycatalog.Steps to Reproduce
duckgres.yaml:psql "host=localhost user=test dbname=test sslmode=require"Test Setup