Postgresql 9.2 pg_dump版本不匹配 [英] Postgresql 9.2 pg_dump version mismatch

问题描述

我正在尝试使用 pg_dump 工具转储Postgresql数据库。

I am trying to dump a Postgresql database using the pg_dump tool.

$ pg_dump books > books.out

我怎么会遇到此错误。

How ever i am getting this error.

pg_dump: server version: 9.2.1; pg_dump version: 9.1.6
pg_dump: aborting because of server version mismatch

The -ignore-version 选项现在已被弃用，即使解决了问题，它实际上也不是我的解决方案。

The --ignore-version option is now deprecated and really would not be a a solution to my issue even if it had worked.

如何升级 pg_dump 来解决此问题？

How can I upgrade pg_dump to resolve this issue?

推荐答案

您可以安装PostgreSQL 9.2。 1在 pg_dump 客户端计算机中，或仅将 $ PGHOME 从PostgreSQL服务器计算机复制到客户端计算机。请注意，无需在客户端计算机中 initdb 新建群集。

You can either install PostgreSQL 9.2.1 in the pg_dump client machine or just copy the $PGHOME from the PostgreSQL server machine to the client machine. Note that there is no need to initdb a new cluster in the client machine.

完成安装后， 9.2.1软件，请记住在 .bash_profile 文件中编辑一些环境变量。

After you have finished installing the 9.2.1 software, remember to edit some environment variables in your .bash_profile file.

这篇关于Postgresql 9.2 pg_dump版本不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！