postgresql PgAdmin 在单击 SQL 查询按钮时有时会崩溃
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13866157/
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
PgAdmin sometimes crash when clicking SQL query button
提问by Pavel V.
I know this question may be seen as a duplicate with this one. I even have almost the same configuration (PostgreSQL 9.1.3, pgAdmin III 1.14.3, 32 bit Windows). What is the difference and the reason I ask a new question is that my PgAdmin doesn't crash always (just mostly) and that the cause of the problem is different - in linked question the problem was with missing adminpack, but I have adminpack installed and it works well, so the answer for linked question doesn't work for me.
我知道这个问题可以被看作是一个重复的这一个。我什至有几乎相同的配置（PostgreSQL 9.1.3、pgAdmin III 1.14.3、32 位 Windows）。有什么区别，我问一个新问题的原因是我的 PgAdmin 不会总是崩溃（只是大部分）并且问题的原因是不同的 - 在链接问题中，问题是缺少 adminpack，但我安装了 adminpack并且效果很好，因此链接问题的答案对我不起作用。
Do you have any ideas where the problem could be?
你有什么想法可能出问题吗？
EDIT: PgAdmin doesn't crash at other occasions (well, unless I do someting that obviously deserves a crash), just while trying to open SQL query window. It's worse and worse as time goes on, now it's almost "always". The problem is not "connection specific" - frequence of crashing is the same for different server connections.
编辑：PgAdmin 在其他情况下不会崩溃（好吧，除非我做了一些明显应该崩溃的事情），只是在尝试打开 SQL 查询窗口时。随着时间的推移，情况越来越糟，现在几乎“总是”。问题不是“特定于连接的” - 不同服务器连接的崩溃频率相同。
EDIT2: I reinstalled PgAdmin and nothing have changed. I'm starting to suspect PostgreSQL 9.1.3 or even PostGIS 2.0.1 of the problem.
EDIT2：我重新安装了 PgAdmin，但没有任何改变。我开始怀疑 PostgreSQL 9.1.3 甚至 PostGIS 2.0.1 的问题。
采纳答案by Erwin Brandstetter
There can be a great many different possible reasons for crashes. Some of them have been fixedin the latest version 1.16.1, release just last week.
You could try the new version and see if that fixes your problem.
导致崩溃的可能原因有很多种。其中一些已在上周发布的最新版本 1.16.1 中得到修复。
您可以尝试新版本，看看是否能解决您的问题。
回答by Ashwath
- Goto run and type %appdata% and go inside postgresql folder.
- rename or delete pgadmin_histoqueries.xml file.
- try opening the SQL query editor again.
- 转到运行并输入 %appdata% 并进入 postgresql 文件夹。
- 重命名或删除 pgadmin_histoqueries.xml 文件。
- 再次尝试打开 SQL 查询编辑器。
Good luck!
祝你好运！
回答by Joshua Burns
PgAdmin crashes on me all of the time, but you eventually learn to be gentle with it.
PgAdmin 一直在我身上崩溃，但你最终学会了对它温和。
Particularly, if it is waiting for a response from the PostgreSQL server, the window may freeze up until a reply is returned and parsed. When this happens, do notclose the window, just wait.
特别是，如果它正在等待来自 PostgreSQL 服务器的响应，则窗口可能会冻结，直到返回并解析响应为止。发生这种情况时，做到不关闭窗口，只是等待。
Also, if you attempt to edit two different objects on the same parent, save one and click save on the other, this crashes the program.
此外，如果您尝试在同一个父项上编辑两个不同的对象，保存一个并单击另一个保存，这会使程序崩溃。
My advice would be to only do one thing at a time, be patient, and don't be in a hurry to kill the process when it freezes up.
我的建议是一次只做一件事，要有耐心，不要急于在进程冻结时终止它。
回答by Raja
Pgadmin3 was really unstable after installation on my ubuntu 12.04 LTS. It either freezes or crashes even while doing very basic things like looking data in a table or list tables in a schema etc., I almost gave up and started using the command line psql and luckily stumbled on this blogwhich recommended to remove the pgadmin3 history file to solve the freezes and crashes. It worked for me.
在我的 ubuntu 12.04 LTS 上安装后，Pgadmin3 真的很不稳定。即使在执行非常基本的操作（例如在表中查看数据或在模式中列出表等）时，它也会冻结或崩溃，我几乎放弃并开始使用命令行 psql 并幸运地偶然发现了这个建议删除 pgadmin3 历史记录的博客文件来解决冻结和崩溃问题。它对我有用。
