postgresql - 为什么这个 postgres 数据库升级失败了?
问题描述
我试图从 Postgresql 9.6 升级到 10 失败。
我运行brew upgrade postgresql
成功,然后运行brew postgresql-upgrade-database
失败消息。问题似乎是这一行:
lc_collate values for database "postgres" do not match: old "en_GB.UTF-8", new "en_US.UTF-8"
整个信息是:
==> Upgrading postgresql data from 9.6 to 10...
Stopping `postgresql`... (might take a while)
==> Successfully stopped `postgresql` (label: homebrew.mxcl.postgresql)
==> Moving postgresql data from /usr/local/var/postgres to /usr/local/var/postgres.o
The files belonging to this database system will be owned by user "jbkimac".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /usr/local/var/postgres ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
/usr/local/opt/postgresql/bin/pg_ctl -D /usr/local/var/postgres -l logfile start
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for reg* data types in user tables ok
Checking for contrib/isn with bigint-passing mismatch ok
Checking for invalid "unknown" user columns ok
Creating dump of global objects ok
Creating dump of database schemas
ok
lc_collate values for database "postgres" do not match: old "en_GB.UTF-8", new "en_US.UTF-8"
Failure, exiting
Error: Upgrading postgresql data from 9.6 to 10 failed!
==> Removing empty postgresql initdb database...
==> Moving postgresql data back from /usr/local/var/postgres.old to /usr/local/var/p
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)
Error: Failure while executing; `/usr/local/opt/postgresql/bin/pg_upgrade -r -b /usr/local/Cellar/postgresql/9.6.1/bin -B /usr/local/opt/postgresql/bin -d /usr/local/var/postgres.old -D /usr/local/var/postgres -j 8` exited with 1.
任何人都可以帮助建议我如何解决这个"en_GB.UTF-8", new "en_US.UTF-8"
冲突问题吗?
解决方案
brew services stop postgresql
brew postgresql-upgrade-database
brew services start postgresql
推荐阅读
- javascript - 使用 RXJS 5 对搜索进行分页
- docker - 如果主节点在 Kubernetes 中死亡会发生什么?如何解决问题?
- video - tus 上传到 Vimeo 不会恢复并且总是重新启动
- javascript - 使用 setTimeout 暂停执行添加动画
- java - Spring boot中构造函数调用的顺序
- java - 如何在Android中完全执行第一种方法后执行第二种方法?
- node.js - 如何将 2checkout 与 reactjs 和 nodejs 集成?
- python - 如何在python(netmiko)中从循环中获取多个输出到外部
- android - Flutter/我的应用程序无法加载到模拟器或真实设备?
- spf - 是否可以合并这 2 条 SPF 记录?