Postgres语言环境错误 [英] Postgres locale error

问题描述

我在Digital River，Ubuntu和

I have a Postgres database hosted on Digital River, on Ubuntu, and followed these instructions to install:

但是语言环境设置有问题，我无法解决该问题.当我运行psql命令时，出现以下错误:

But something is wrong with the locale settings and I cannot work out how to fix it. When I run the psql command I get the following error:

postgres@assay:/home/deployer$ psql
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US:en",
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
psql (9.1.9)

推荐答案

非常感谢Digital River论坛上的Kamal Nasser提供正确的答案(以下以下命令需要root权限):

Thank you very much to Kamal Nasser on the Digital River forums for providing the correct answer (the following commands below requires root privileges):

$ locale-gen en_US en_US.UTF-8 
$ dpkg-reconfigure locales

我认为这是原始答案的正确链接:Digital Ocean网站没有响应，因此我无法对其进行检查. https://www.digitalocean.com/community/questions/postgresql-and-rails-4

I think this is the correct link to the original answer: the Digital Ocean site is not responding so I can't check it. https://www.digitalocean.com/community/questions/postgresql-and-rails-4

这篇关于Postgres语言环境错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！