psql错误信息显示为?
时间:2010-09-17
来源:互联网
在ubuntu10.4下,使用psql,出错时,显示信息为???号,请问如何处理?
/etc/postgresql/8.4/main/postgresql.conf的相关设置是:
client_encoding = UTF8 # actually, defaults to database
# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'zh_CN.UTF-8' # locale for system error message
# strings
lc_monetary = 'zh_CN.UTF-8' # locale for monetary formatting
lc_numeric = 'zh_CN.UTF-8' # locale for number formatting
lc_time = 'zh_CN.UTF-8' # locale for time formatting
报错信息如下:
sup@my-desktop:~$ psql -U postgres
psql: ????: ?? "postgres" Ident ????
-----------------------------
请问要怎么设置菜可以把错误信息显示出来?最好是显示为英文。我在lc_messages那里设置为en_US或en_US.UTF-8都不行,还是显示为?号。
谢谢!
/etc/postgresql/8.4/main/postgresql.conf的相关设置是:
client_encoding = UTF8 # actually, defaults to database
# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'zh_CN.UTF-8' # locale for system error message
# strings
lc_monetary = 'zh_CN.UTF-8' # locale for monetary formatting
lc_numeric = 'zh_CN.UTF-8' # locale for number formatting
lc_time = 'zh_CN.UTF-8' # locale for time formatting
报错信息如下:
sup@my-desktop:~$ psql -U postgres
psql: ????: ?? "postgres" Ident ????
-----------------------------
请问要怎么设置菜可以把错误信息显示出来?最好是显示为英文。我在lc_messages那里设置为en_US或en_US.UTF-8都不行,还是显示为?号。
谢谢!
作者: lunarwildgoose 发布时间: 2010-09-17
忘了贴上我的locale,补上
sup@my-desktop:~$ locale
LANG=zh_CN.UTF-8
LANGUAGE=en
LC_CTYPE=zh_CN.UTF-8
LC_NUMERIC="zh_CN.UTF-8"
LC_TIME="zh_CN.UTF-8"
LC_COLLATE="zh_CN.UTF-8"
LC_MONETARY="zh_CN.UTF-8"
LC_MESSAGES="zh_CN.UTF-8"
LC_PAPER="zh_CN.UTF-8"
LC_NAME="zh_CN.UTF-8"
LC_ADDRESS="zh_CN.UTF-8"
LC_TELEPHONE="zh_CN.UTF-8"
LC_MEASUREMENT="zh_CN.UTF-8"
LC_IDENTIFICATION="zh_CN.UTF-8"
LC_ALL=
sup@my-desktop:~$ locale
LANG=zh_CN.UTF-8
LANGUAGE=en
LC_CTYPE=zh_CN.UTF-8
LC_NUMERIC="zh_CN.UTF-8"
LC_TIME="zh_CN.UTF-8"
LC_COLLATE="zh_CN.UTF-8"
LC_MONETARY="zh_CN.UTF-8"
LC_MESSAGES="zh_CN.UTF-8"
LC_PAPER="zh_CN.UTF-8"
LC_NAME="zh_CN.UTF-8"
LC_ADDRESS="zh_CN.UTF-8"
LC_TELEPHONE="zh_CN.UTF-8"
LC_MEASUREMENT="zh_CN.UTF-8"
LC_IDENTIFICATION="zh_CN.UTF-8"
LC_ALL=
作者: lunarwildgoose 发布时间: 2010-09-17
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28