PostgreSQL 提示 The database was created using collation version 2.31, but the operating system provides version 2.36

该问题是数据库更新后排序规则变动导致的。使用下面的命令更新更新排序规则库

“`

ALTER DATABASE <your-database-name> REFRESH COLLATION VERSION;

“`

参考资料:

https://forum.greenbone.net/t/the-database-was-created-using-collation-version-2-35-but-the-operating-system-provides-version-2-36/13562/3

https://dba.stackexchange.com/questions/324649/collation-version-mismatch

上一篇
下一篇