postgresql – 在升级9.5到9.6期间无法创建目标群集

概述我在ubuntu 16.04上,并在其上安装postgres 9.5 然后我将postgres 9.5升级到9.6,然后按照postgresql offical download page安装9.6： 然后我运行apt install postgresql-9.6,安装完成后,运行以下命令进行升级 # stop the 9.6 $sudo pg_dropcluster 9.6 main --st 我在ubuntu 16.04上,并在其上安装postgres 9.5

然后我将postgres 9.5升级到9.6,然后按照postgresql offical download page安装9.6：

然后我运行apt install postgresql-9.6,安装完成后,运行以下命令进行升级

# stop the 9.6 $sudo pg_dropcluster 9.6 main --stop# upgrade 9.5 to latest version$sudo pg_upgradecluster 9.5 mainsudo pg_upgradecluster 9.5 mainStopPing old cluster...Notice: extra pg_ctl/postgres options given,bypassing systemctl for stop operationdisabling connections to the old cluster during upgrade...Restarting old cluster with restricted connections...Redirecting start request to systemctlperl: 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 a fallback locale ("en_US.UTF-8").Error: The locale requested by the environment is invalID.Error: Could not create target cluster

然后我尝试使用psql命令连接旧集群.但是错误：

$psql -U postgres -h localhostpsql: FATAL:  no pg_hba.conf entry for host "::1",user "postgres",database "postgres",SSL onFATAL:  no pg_hba.conf entry for host "::1",SSL off

似乎pg_hba.conf是错误的,然后我在/etc/postgresql/9.5/main/pg_hba.conf检查pg_hba.conf,但看起来很好：

local   all             postgres                                peer

解决方法 我能找到解决此问题的唯一解决方案是运行以​​下命令：

export LC_CTYPE=en_US.UTF-8 export LC_ALL=en_US.UTF-8

在继续sudo pg_upgradecluster 9.5 main之前

总结

以上是内存溢出为你收集整理的postgresql – 在升级9.5到9.6期间无法创建目标群集全部内容，希望文章能够帮你解决postgresql – 在升级9.5到9.6期间无法创建目标群集所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。