postgresql - 由于服务器版本不匹配而中止

Question

我试图在 pg_dump 的帮助下进行模式备份，但失败并出现以下错误。

# pg_dump -hq2vy.us-east-1.rds.amazonaws.com -U username -n schema > ouput.sql
pg_dump: server version: 9.3.14; pg_dump version: 9.2.18
pg_dump: aborting because of server version mismatch

安装的版本架构为

转速-qa | grep postgresql93*

postgresql92-libs-9.2.18-1.59.amzn1.x86_64

所以我尝试安装x64版本，但也失败了，出现以下错误

# yum install  postgresql93-9.3.14-1.62.amzn1.x86_64
Loaded plugins: priorities, update-motd, upgrade-helper
Resolving Dependencies
--> Running transaction check
---> Package postgresql93.x86_64 0:9.3.14-1.62.amzn1 will be installed
--> Processing Dependency: postgresql93-libs(x86-64) = 9.3.14-1.62.amzn1 for package: postgresql93-9.3.14-1.62.amzn1.x86_64
--> Running transaction check
---> Package postgresql93-libs.i686 0:9.3.14-1.62.amzn1 will be updated
---> Package postgresql93-libs.x86_64 0:9.3.14-1.62.amzn1 will be installed
---> Package postgresql93-libs.i686 0:9.3.17-1.63.amzn1 will be an update
--> Finished Dependency Resolution
Error:  Multilib version problems found. This often means that the root
       cause is something else and multilib version checking is just
       pointing out that there is a problem.

有人可以帮忙吗？

Answer 1

我已经通过安装包 postgresql93.x86_64 修复了它