错误迁移 pgsql 导致日志报 warning,请问如何解决?

28次阅读

共计 996 个字符,预计需要花费 3 分钟才能阅读完成。

换系统的时候图简单脑子抽抽了,直接 tar czf /var/lib/postgresql。后解压放到新系统 /var/lib 目录下, 没有用 dump pgloader 之类的工具。现在所有的 database 一直报同一个错,不重建所有数据库可以解决吗?
报错如下,查询 gemini/gpt3.5 无果,尝试 ALTER DATABASE xxx REFRESH COLLATION VERSION; 显示 invalid collation version. 请问大佬们如何解决?

"2024-04-28 10:07:27.248 CST [3392] WARNING: database"template1"has no actual collation version, but a version was recorded",
"2024-04-28 10:07:39.298 CST [3393] WARNING: database"postgres"has no actual collation version, but a version was recorded",
"2024-04-28 10:07:49.150 CST [3398] WARNING: database"vaultwarden"has no actual collation version, but a version was recorded",
"2024-04-28 10:07:49.150 CST [3399] WARNING: database"vaultwarden"has no actual collation version, but a version was recorded",
"2024-04-28 10:07:51.323 CST [3400] WARNING: database"vaultwarden"has no actual collation version, but a version was recorded",
"2024-04-28 10:08:03.244 CST [3401] WARNING: database"miniflux"has no actual collation version, but a version was recorded",
"2024-04-28 10:08:15.275 CST [3402] WARNING: database"core"has no actual collation version, but a version was recorded",
正文完
 0