postgresql 编码UTF8与区域设置en_US不匹配;所选LC_CTYPE设置需要编码LATIN 1

ifsvaxew 于 2022-12-26 发布在 PostgreSQL

关注(0)|答案(8)|浏览(483)

尝试安装opennms时：

/usr/share/opennms/bin/install -l /usr/local/lib -dis

我得到错误：
错误：编码UTF8与区域设置en_US不匹配详细信息：所选的LC_CTYPE设置需要对LATIN1进行编码。
我不确定如何继续，因为我尝试过几种不同的方法来创建DB（见下文）。
完整日志：

==============================================================================
OpenNMS Installer
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- searching for jicmp:
  - trying to load /usr/local/lib/libjicmp.so: NO
  - trying to load /usr/lib/jni/libjicmp.so: OK
- searching for jicmp6:
  - trying to load /usr/local/lib/libjicmp6.so: NO
  - trying to load /usr/lib/jni/libjicmp6.so: OK
- searching for jrrd:
  - trying to load /usr/local/lib/libjrrd.so: NO
  - trying to load /usr/lib/jni/libjrrd.so: NO
  - trying to load /usr/lib/jni/libjrrd.so: NO
  - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/lib/amd64/server/libjrrd.so: NO
  - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/lib/amd64/libjrrd.so: NO
  - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/../lib/amd64/libjrrd.so: NO
  - trying to load /libjrrd.so: NO
  - trying to load /usr/share/opennms/lib/libjrrd.so: NO
  - trying to load /usr/share/opennms/lib/linux64/libjrrd.so: NO
  - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO
  - trying to load /usr/lib64/libjrrd.so: NO
  - trying to load /lib64/libjrrd.so: NO
  - trying to load /lib/libjrrd.so: NO
  - trying to load /usr/lib/libjrrd.so: NO
  - trying to load /usr/lib/jni/libjrrd.so: NO
  - trying to load /usr/lib/libjrrd.so: NO
  - trying to load /usr/local/lib/libjrrd.so: NO
  - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO
  - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO
  - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO
  - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO
- Failed to load the optional jrrd library.
  - This error is not fatal, since jrrd is only required for optional features.
  - For more information, see http://www.opennms.org/index.php/jrrd
- using SQL directory... /usr/share/opennms/etc
- using create.sql... /usr/share/opennms/etc/create.sql
* using 'postgres' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
Exception in thread "main" org.opennms.core.schema.MigrationException: an error occurred creating the OpenNMS database
    at org.opennms.core.schema.Migrator.createDatabase(Migrator.java:428)
    at org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:444)
    at org.opennms.install.Installer.install(Installer.java:236)
    at org.opennms.install.Installer.main(Installer.java:949)
Caused by: org.postgresql.util.PSQLException: ERROR: encoding UTF8 does not match locale en_US
  Detail: The chosen LC_CTYPE setting requires encoding LATIN1.
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
    at org.opennms.core.schema.Migrator.createDatabase(Migrator.java:425)
    ... 3 more

数据库列表：

Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   
-----------+----------+----------+---------+-------+-----------------------
 postgres  | postgres | LATIN1   | en_US   | en_US | 
 rhq       | rhqadmin | LATIN1   | en_US   | en_US | 
 template0 | postgres | LATIN1   | en_US   | en_US | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 template1 | postgres | LATIN1   | en_US   | en_US | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
(4 rows)

我已经使用了以下3个initdb选项，但它们都不起作用

/usr/local/pgsql/bin/initdb -E UTF-8 --pgdata=/usr/local/pgsql/data

/usr/local/pgsql/bin/initdb -E LATIN1 --pgdata=/usr/local/pgsql/data

/usr/local/pgsql/bin/initdb -E en_US.UTF8  --pgdata=/usr/local/pgsql/data

另外，在使用initdb之前，是否需要删除/usr/local/pgsql/data中的所有数据？
附加区域设置命令stdout：
$语言环境

LANG=en_US
LANGUAGE=en_US:
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=

postgresql

来源：https://stackoverflow.com/questions/13115692/encoding-utf8-does-not-match-locale-en-us-the-chosen-lc-ctype-setting-requires

8条答案

按热度按时间

cbjzeqam1#

我结合了其他网站的两个解决方案（这个答案适用于Ubuntu Server 12.04和PGSQL 9.1）：

创建一个文件：nano /etc/profile.d/lang.sh.
增加以下内容：

export LANGUAGE="en_US.UTF-8"
export LANG="en_US.UTF-8"
export LC_ALL="en_US.UTF-8"

保存文件
重新启动shell或在当前shell示例中手动运行所有导出命令
重新配置以便编码可以是UTF8（[从此处获得][1]）

sudo su postgres

psql

update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8'

  lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

update pg_database set datistemplate=true where datname='template1';

使用template1创建数据库。

赞(0）回复(0）举报 2022-12-26

nwlls2ji2#

感谢locale输出。OpenNMS似乎使用了您的en_US（非UTF-8）语言环境来创建postgres数据库，这是错误的。

export LANG=en_US.UTF-8
locale   # confirm that it shows only en_US.UTF-8 for all settings
# finally, run your opennms installer
/usr/share/opennms/bin/install -l /usr/local/lib -dis

赞(0）回复(0）举报 2022-12-26

hgb9j2n63#

这对我很有效：

CREATE DATABASE mydb WITH ENCODING='UTF8' LC_CTYPE='en_US.UTF-8' LC_COLLATE='en_US.UTF-8' OWNER=postgres TEMPLATE=template0 CONNECTION LIMIT=-1;

赞(0）回复(0）举报 2022-12-26

7vux5j2d4#

发生这种情况的原因是您的系统设置为使用Latin 1编码而不是UTF-8。您的语言已正确设置为en_US，但编码未设置为UTF-8。请尝试运行以下命令：$

localedef -v -c -i en_US -f UTF-8 en_US.UTF-8

这将设置告诉你的所有应用程序安装后的变化（我认为）使用英语与unicode编码。更多信息可以在这里找到：https://www.linux.com/learn/docs/ldp/790-Unicode-HOWTO#s3
我也有类似的问题，所以我：
1.属性清除postresql...
1.本地定义f-v -c -i en_US -f UTF-8 en_US.UTF-8

aptitude安装后resql....
然后PostRegSQL知道将其自身设置为使用具有Unicode编码的英语语言。
当然，您可以按每个数据库执行此操作，如下所述：http://www.postgresql.org/docs/9.1/static/multibyte.html

赞(0）回复(0）举报 2022-12-26

f4t66c6m5#

我也犯了同样的错误：

ERROR:  new collation (en_US.utf8) is incompatible with the collation of the template database (en_US.UTF-8)
HINT:  Use the same collation as in the template database, or use template0 as template.

- 解决方案：**

dpkg-reconfigure locales (choose en_US.UTF-8)

然后：

sudo -u postgres psql  

postgres=# update pg_database set datistemplate=false where datname='template1';  
UPDATE 1  
postgres=# drop database Template1;  
DROP DATABASE  
postgres=# create database template1 with owner=postgres encoding='UTF-8'  
postgres-# lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;  
CREATE DATABASE  
postgres=# update pg_database set datistemplate=true where datname='template1';  
UPDATE 1

- 测试：**

postgres=# CREATE DATABASE Person  
    WITH 
    OWNER = Person  
    ENCODING = 'UTF8'  
    LC_COLLATE = 'en_US.utf8'  
    LC_CTYPE = 'en_US.utf8'  
    TABLESPACE = pg_default  
    CONNECTION LIMIT = -1;  
CREATE DATABASE

它的工作原理：）

赞(0）回复(0）举报 2022-12-26

yacmzcpb6#

更改SO的区域设置和语言，以与BD兼容。

dpkg-重新配置语言环境

好好享受吧!

赞(0）回复(0）举报 2022-12-26

snz8szmq7#

我遇到了类似的错误。旧的数据库LC_CTYPE是UTF-8，而新的数据库是en_US.UTF-8，我重新初始化数据库后解决了这个问题。

initdb --pgdata=/path/to/postgresql -E utf8

您应该选择正确的-E参数

赞(0）回复(0）举报 2022-12-26

h22fl7wq8#

我在安装odoo的时候遇到过“同样的问题”。原来在安装odoo之前，你必须配置locale

export LC_CTYPE="en_US.UTF-8"
sudo dpkg-reconfigure locales

然后用UTF-8配置locale，但是你必须在安装posgres之前配置locale。

赞(0）回复(0）举报 2022-12-26

我来回答

postgresql 编码UTF8与区域设置en_US不匹配;所选LC_CTYPE设置需要编码LATIN 1

8条答案

dpkg-重新配置语言环境

相关问题

热门标签

最新问答