PostHog / PostHog/duckgres

file_persistence: true breaks standalone mode — "No catalog + schema named memory found"

Open
#561 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
180
Forks
18
Avg merge
10h 44m
Merged PRs (30d)
85

Description

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

  1. 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"
  1. Run duckgres in standalone mode (default)
  2. 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

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the standalone configuration with file_persistence enabled and tracing the session setup that switches to the memory schema after authentication. Confirm the fix by connecting with psql against the file-backed database and verifying that sessions no longer fail with the catalog/schema error.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.