合 DETAIL: The database was initialized with LC_COLLATE "en_US.utf8"
Tags： PG故障处理PostgreSQL启动报错
👉 本文共约106个字，系统预计阅读时间或需1分钟。
现象
PostgreSQL无论远程还是本地登录都报错：
1 2 3 | 2023-04-04 12:13:26.858 CST [121] FATAL: database locale is incompatible with operating system 2023-04-04 12:13:26.858 CST [121] DETAIL: The database was initialized with LC_COLLATE "en_US.utf8", which is not recognized by setlocale(). 2023-04-04 12:13:26.858 CST [121] HINT: Recreate the database with another locale or install the missing locale. |
分析
语言包配置问题。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
