postgresql pgAdmin III 中没有备份和恢复选项
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/28045293/
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
Backup and Restore option not available in pgAdmin III
提问by Pradnya
I have to take backup of my database but when I right click DB and then backup The button for backup is disabled. Similarly in existing database ,not able to restore because the Restore button too disabled. I was working fine till the time I created a new database.
我必须备份我的数据库，但是当我右键单击 DB 然后备份 备份按钮被禁用。同样在现有数据库中，由于“恢复”按钮太禁用而无法恢复。在创建新数据库之前，我一直工作正常。
How do they get enabled?
它们是如何启用的？
回答by Ledazinha
I had the same problem in ubuntu 14.04. It was necessary to install both postgresql-client-common (which contains pg_dump and pg_restore) andpostgresql-client packages.
我在 ubuntu 14.04 中遇到了同样的问题。有必要安装 postgresql-client-common（包含 pg_dump 和 pg_restore）和postgresql-client 包。
回答by Ramunas
There is no need for reinstall,
just open File->Options->Binary paths and add set "PG bin path" to path where pg_dump/pg_restore is located.
无需重装，打开File->Options->Binary paths，在pg_dump/pg_restore所在的路径添加set“PG bin path”即可。
回答by Mario García
Here is a solution:
这是一个解决方案：
$ yum install postgresql-contrib
回答by rsc
Problem could be caused by a fact that you simply do not have pg_dump and pg_restore tools installed (or they are not visible for pgadmin).
问题可能是由于您根本没有安装 pg_dump 和 pg_restore 工具（或者它们对 pgadmin 不可见）造成的。
This had happen to me when installing pgadmin3 on CentOS 7 via PostgreSQL yum repository. To resolve this I had to install package with those tools - in my case postgresql94 (PostgreSQL client programs and libraries).
这发生在我通过PostgreSQL yum 存储库在 CentOS 7 上安装 pgadmin3 时。为了解决这个问题，我必须使用这些工具安装包 - 在我的例子中是 postgresql94（PostgreSQL 客户端程序和库）。
On other distros you will need to find which package should be installed. AFAIK this issue is not present in Windows environment, pgadmin installer probably have all needed dependencies.
在其他发行版上，您需要找到应该安装哪个包。AFAIK 这个问题在 Windows 环境中不存在，pgadmin 安装程序可能具有所有需要的依赖项。
回答by Erik_van_der_Arend
Just reinstall your PGAdmin3.
只需重新安装您的 PGAdmin3。
We had the same problem on a Mac and after reinstallation, the right click menu showed more options like "Restore" and "Backup".
我们在 Mac 上遇到了同样的问题，重新安装后，右键单击菜单显示了更多选项，如“恢复”和“备份”。
回答by Zanon
I had this issue (restore button disabled) and the problem was a corrupted dump.
我遇到了这个问题（恢复按钮被禁用），问题是一个损坏的转储。
So, I've created a new dump and tried again. After selecting the new file, the button became available.
所以，我创建了一个新的转储并再次尝试。选择新文件后，按钮变为可用。
回答by sh6210
in my case i'm on windows,
就我而言，我在窗户上，
if python isn't installed, install it.
如果未安装python，请安装它。
restart, and you're done.
重新启动，你就完成了。
