Help: Failed to switch from SQLite to PostgreSQL

[gongliqi2-boop]

Help: Failed to switch from SQLite to PostgreSQL

In the mcp-host @ 0ad315a project, there is a script ./scripts/run_pg.sh which should allow switching to PostgreSQL.

I’ve already updated the frontend code in constant.ts to use the following DEF_DIVE_HTTPD_CONFIG:

{
  "db": {
    "uri": `postgresql://mcp:mcp@10.10.0.2:5444/mcp`,
    "pool_size": 5,
    "pool_recycle": 60,
    "max_overflow": 10,
    "echo": false,
    "pool_pre_ping": true,
    "migrate": true
  },
  "checkpointer": {
    "uri": `postgresql://mcp:mcp@10.10.0.2:5444/mcp`
  }
}

I also replaced the database config in several dive_httpd.json files with the same PostgreSQL connection string:

{
  "db": {
    "uri": "postgresql://mcp:mcp@10.10.0.2:5444/mcp",
    "pool_size": 5,
    "pool_recycle": 60,
    "max_overflow": 10,
    "echo": false,
    "pool_pre_ping": true,
    "migrate": true
  },
  "checkpointer": {
    "uri": "postgresql://mcp:mcp@10.10.0.2:5444/mcp"
  }
}

However, after starting the service, it gets stuck at loading (white screen).
It seems that the database auto-migration is missing several tables (e.g. writes, checkpoints).

I manually synced the schema and data from SQLite to PostgreSQL, but after starting, it still throws connection errors:

return current.parent.switch(awaitable)
...
asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "mcp"

As a result, the dialog list cannot sync.
But actually, the PostgreSQL server has no connection restrictions.

👉 What should I do to make this work?

[ckaznable]

@gongliqi2-boop You can either pull the latest version of mcp-host directly, or apply this commit change directly.

OpenAgentPlatform/dive-mcp-host@7454eb5