将PostgreSQL服务器错误消息的语言更改为英语 [英] Change language of the PostgreSQL server error messages to English

问题描述

我的MS Windows系统是法语版本。我最近安装了PostgreSQL服务器。尽管pgAdmin是英语，但我在PostgreSQL psql命令行中收到法语消息。

My MS Windows system is French version. I've recently installed PostgreSQL server. Although pgAdmin is in English I get French messages in the PostgreSQL psql command line.

推荐答案

如果您有权访问 $ datadir\postgresql.conf 将 lc_messages 参数更改为 English_United States.1252 。您需要重新加载配置（重新启动服务器）。

If you have permissions for access to $datadir\postgresql.conf change lc_messages parameter to English_United States.1252. You need to reload configuration (do restart of the server).

我的配置是：

# These settings are initialized by initdb, but they can be changed.
lc_messages = 'English_United States.1252'  # locale for system error message

# strings
lc_monetary = 'English_United States.1252'  # locale for monetary formatting
lc_numeric = 'English_United States.1252'   # locale for number formatting
lc_time = 'English_United States.1252'      # locale for time formatting

# default configuration for text search
default_text_search_config = 'pg_catalog.english'

这篇关于将PostgreSQL服务器错误消息的语言更改为英语的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！