更换 pgvector:pg18 后聊天记录 JSON 文件无法导入

[gemnioo]

升级 lobehub/lobe-chat-database 到 lobehub/lobehub 前升级并备份了 pgvector 到 pg:18 (之前一直是 pg:18

但：

PostgreSQL 18+ now uses version-specific data directories (like /var/lib/postgresql/18/docker) instead of the generic /var/lib/postgresql/data. Your current mount configuration is causing a conflict. update claim

Key Change
Before: -v postgres_vector:/var/lib/postgresql/data
After: -v postgres_vector:/var/lib/postgresql
This allows PostgreSQL 18 to create its version-specific subdirectory (18/docker) automatically.

重新更换 -v 路径后始终无法导致 只有 2M 的聊天记录 suffix name LobeHub-data.json 查看 pgvector 的发现持续重复的如下日志

2025-11-24 09:18:46.658 UTC [22643] DETAIL:  Role "pguser" does not exist.
        Connection matched file "/var/lib/postgresql/18/docker/pg_hba.conf" line 128: "host all all all scram-sha-256"
2025-11-24 09:18:47.790 UTC [22644] FATAL:  password authentication failed for user "pgsql"
2025-11-24 09:18:47.790 UTC [22644] DETAIL:  Role "pgsql" does not exist.
        Connection matched file "/var/lib/postgresql/18/docker/pg_hba.conf" line 128: "host all all all scram-sha-256"
2025-11-24 09:19:39.798 UTC [22648] FATAL:  password authentication failed for user "postgres"
2025-11-24 09:19:39.798 UTC [22648] DETAIL:  Connection matched file "/var/lib/postgresql/18/docker/pg_hba.conf" line 128: "host all all all scram-sha-256"
2025-11-24 09:22:49.972 UTC [22655] FATAL:  password authentication failed for user "postgres"
2025-11-24 09:22:49.972 UTC [22655] DETAIL:  Connection matched file "/var/lib/postgresql/18/docker/pg_hba.conf" line 128: "host all all all scram-sha-256"

按照文档好像只需要配置 密码即可.. 为何日志中会有大量的 Role/password 错误？

并不确定导入日聊天记录和以上错误之间的关系！导入聊天记录会卡死在 73% 85% 或者随机的百分比数字上

[arvinxx]

理论上应该没关系，我建议你试试看原来老的 db 版本，前段时间我看有一个 pg 版本升级的大问题： https://mp.weixin.qq.com/s/9q68rfefIVdU9cjwDfUxGg

[gemnioo]

这篇文章 前几天广泛流传读过. 但应该不是这种原因? 虽然用的我遇到是拉取同一个 tag:pg18 的镜像 但我并没有保留数据.

现在是 LobeChat JSON 的历史记录文件无法成功导入 全新构建的 pgvector

或者我有空指定镜像 pg18-bookworm 再试试! 但我搜了下 Docker Hub 应该 pull 到的都是 sha256:6b0db4f3c4269c2b49043fe91b00a15b1e1412a55d00b6a99ad84273eee94303 这个镜像