如何让 pgAdmin III 版本与 PostgreSQL 9.4 (Ubuntu 14.10 x64) 一起正常工作?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/29801919/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-09 05:57:42  来源:igfitidea点击:

How to get a version of pgAdmin III working correctly with the PostgreSQL 9.4 (Ubuntu 14.10 x64)?

postgresqlubuntupgadmin

提问by Andriy

I have installed postgresql-9.4and pgAdmin IIIon Ubuntu 14.10 x64:

我已经在Ubuntu 14.10 x64上安装了postgresql-9.4pgAdmin III

sudo apt-get update && sudo apt-get dist-upgrade
sudo apt-get install postgresql-9.4
sudo apt-get pgadmin3

However using pgAdminwith PostgreSQLI faced with the warning

但是,将pgAdminPostgreSQL一起使用时,我遇到了警告

Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III.

pgAdmin III may not function as expected.

Supported server versions are 8.4 to 9.3.

警告:您正在连接的服务器不是此版本的 pgAdmin III 支持的版本。

pgAdmin III 可能无法按预期运行。

支持的服务器版本为 8.4 到 9.3。

1) How to get a version of pgAdmin IIIdo I use?

1) 如何获得 我使用的pgAdmin III版本?

2) How to uninstall current version of pgAdminand to install the correct version of pgAdmin?

2) 如何卸载当前版本的pgAdmin并安装正确版本的pgAdmin

Thank you.

谢谢你。

采纳答案by Robin Nabel

It seems to be a known bug: link

这似乎是一个已知的错误:链接

The bug thread suggests to try and use pgAdmin 1.20. You can download it here: link

该错误线程建议尝试使用 pgAdmin 1.20。你可以在这里下载:链接

回答by mivk

PostgreSQL maintains a repository of apt packages. You can follow the instructions on their wiki at https://wiki.postgresql.org/wiki/Apt

PostgreSQL 维护着一个 apt 包的存储库。您可以按照其 wiki 上的说明进行操作,网址https://wiki.postgresql.org/wiki/Apt

Basically, they boil down to:

基本上,它们归结为:

# add the repository
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

# install their key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

Then

然后

sudo apt-get install pgadmin3

That worked fine for me on Ubuntu 12.04, and I have now pgadmin3 v. 1.20.

在 Ubuntu 12.04 上这对我来说效果很好,我现在有了 pgadmin3 v. 1.20。