postgresql pgAdmin 无法启动(永久加载)
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/43184343/
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 won't start (eternal loading)
提问by pedroth
Once upon a time I had a Postgres database that worked with pgAdmin. I have a webservice running on a WildFly server that made connections to the DB and everything worked fine.
曾几何时,我有一个与 pgAdmin 一起工作的 Postgres 数据库。我有一个运行在 WildFly 服务器上的 web 服务,它与数据库建立了连接,一切正常。
After a while(a few months) I have tried to open pgAdmin again and it stuck on the loading...
一段时间(几个月)后,我尝试再次打开 pgAdmin,但它卡在加载中...
I remove postgres and pgAdmin using Revo Uninstall, then installed postgres 9.6 and opened pgAdmin and it stays in the loading screen forever.
我使用 Revo Uninstall 删除 postgres 和 pgAdmin,然后安装 postgres 9.6 并打开 pgAdmin,它永远留在加载屏幕中。
Can anyone help me ? [Using postgres 9.6 with pgAdmin v1.3],
谁能帮我 ?[在 pgAdmin v1.3 中使用 postgres 9.6],
On Event Viewer I saw the following error in pgAdmin :
在事件查看器上,我在 pgAdmin 中看到以下错误:
Faulting application name: pgAdmin4.exe, version: 0.0.0.0, time stamp: 0x580f31f6 Faulting module name: MSVCP120.dll, version: 6.3.9600.18438, time stamp: 0x57ae642e Exception code: 0xc0000135 Fault offset: 0x00000000000ecdd0 Faulting process id: 0x1de4 Faulting application start time: 0x01d2a7d1566324ba Faulting application path: C:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin\pgAdmin4.exe Faulting module path: MSVCP120.dll Report Id: 984dd9d8-13c4-11e7-832d-5ce0c535006f Faulting package full name: Faulting package-relative application ID:
错误的应用程序名称:pgAdmin4.exe,版本:0.0.0.0,时间戳:0x580f31f6 错误的模块名称:MSVCP120.dll,版本:6.3.9600.18438,时间戳:0x57ae642e 异常代码:0xc000010000000c0000c0000c000c03000c000c03000c000c0003000c应用程序启动时间:0x01d2a7d1566324ba 错误应用程序路径:C:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin\pgAdmin4.exe 错误模块路径:MSVCP120.dll 报告 ID:984dd9d8-13c4-11e7-832d-11e7-832d-5000c 全名:错误的包相关应用程序 ID:
采纳答案by svarog
I just had the same issue on a Windows 7, 64bit machine, DBA told me to "upgrade" to pgAdmin 3 (latest build) and it works.
我刚刚在 64 位 Windows 7 机器上遇到了同样的问题,DBA 告诉我“升级”到 pgAdmin 3(最新版本)并且它可以工作。
回答by Darrell Brogdon
I just had this problem on macOS so I went to Terminal and typed ps aux | grep -i pgadmin
and made a note of the process id (second column from the left). Then I killed that process with kill -s TERM <process id>
. You can also use the simpler form with killall pgAdmin4
. Then I was able to start "pgAdmin 4" from the Applications directory.
我刚刚在 macOS 上遇到了这个问题,所以我去终端输入ps aux | grep -i pgadmin
并记下进程 ID(从左数第二列)。然后我用kill -s TERM <process id>
. 您还可以将更简单的形式与killall pgAdmin4
. 然后我就可以从 Applications 目录启动“pgAdmin 4”。
回答by tytk
I had this issue on Mac. I resolved it by:
我在 Mac 上遇到了这个问题。我通过以下方式解决了它:
- Closing the instance of PgAdmin 3 AND PgAdmin4 (I had both open)
- System Preferences -> Security & Privacy -> Allow apps downloaded from: Anywhere
- Reopen PgAdmin4
- 关闭 PgAdmin 3 和 PgAdmin4 的实例(我都打开了)
- 系统偏好设置 -> 安全与隐私 -> 允许从以下位置下载应用程序:任何地方
- 重新打开 PgAdmin4
回答by chhay lyheng
I faced the same issue (on window server) My solution is just open task manager and finds out pg_ctl then just end that task and reopen pgadmin again. It will work!in case it still doesn't work just try to terminate mysql.exe too.
我遇到了同样的问题(在窗口服务器上)我的解决方案是打开任务管理器并找出 pg_ctl 然后结束该任务并再次重新打开 pgadmin。它将起作用!如果它仍然不起作用,也只需尝试终止 mysql.exe。
回答by Henrique Lima
I found a solution here pgAdmin 4 v3.1 How can I use another browser? (Win 7)
我在这里找到了一个解决方案pgAdmin 4 v3.1 如何使用其他浏览器?(赢7)
My pgadmin4 stopped working in firefox but it works in chrome. Now i use this configuration to open pgadmin 4 using chrome. It is interesting that pgadmin4 now open in his own window.
我的 pgadmin4 停止在 Firefox 中工作,但它在 chrome 中工作。现在我使用此配置使用 chrome 打开 pgadmin 4。有趣的是 pgadmin4 现在在他自己的窗口中打开。
I think this is the correct way to use pgadmin4.
我认为这是使用 pgadmin4 的正确方法。
回答by Murtuza Z
Response from pgadmin-support mail group:
来自 pgadmin-support 邮件组的回复:
Please try one of the Mac/Windows test builds at https://developer.pgadmin.org/~dpage/. I would strongly advise doing a complete uninstall before installing, to ensure no old, unused files are left behind.
请在https://developer.pgadmin.org/~dpage/尝试 Mac/Windows 测试版本之一。我强烈建议在安装之前完全卸载,以确保不会留下旧的、未使用的文件。
回答by Victor Castro
I had a similar issue and was able to fix it by re-installing the latest Java JDK x64 8 at http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
我遇到了类似的问题,并且能够通过在http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html重新安装最新的 Java JDK x64 8 来修复它