pgAdmin won't start (eternal loading)

Question

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.

After a while(a few months) I have tried to open pgAdmin again and it stuck on the loading...

I remove postgres and pgAdmin using Revo Uninstall, then installed postgres 9.6 and opened pgAdmin and it stays in the loading screen forever.

Can anyone help me ? [Using postgres 9.6 with pgAdmin v1.3],

On Event Viewer I saw the following error in 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:

Have you seen the windows logs? I suspect that it must be something related with security permissions. — Jorge Campos, Apr 03 '17 at 12:47
Not the postgresql logs, the application logs in windows computer management. Your problem seems to be with the pgAdmin which is just a client for postgresql server. So you need to see if there is any problem with it in windows logs. — Jorge Campos, Apr 03 '17 at 13:04
I am looking to Event Viewer > Windows Logs . To logs with source in Postgres — pedroth, Apr 03 '17 at 13:26
Don't look for postgres, look for pgadmin. They are not the same. — Jorge Campos, Apr 03 '17 at 13:57
In the event viewer I don't see anything from pgadmin or postgress under application logs. I'm on Windows server 2012 r2 . Killing the process doesn't help. I don't have permissions to restart this host. — Malcolm McRoberts, Apr 04 '19 at 16:45
Don't use any version of pgAdmin prior to version 4.29. Junk. — JustBeingHelpful, Jan 20 '21 at 00:23
On Ubuntu 22.04, I needed to downgrade my Python: https://askubuntu.com/a/1461009/48214 — Ryan, Mar 26 '23 at 16:24

score 55 · Answer 1 · edited Jun 05 '23 at 23:23

I had the same problem and I resolved it following the steps on link https://www.pgadmin.org/faq/#12

When I launch pgAdmin 4 v4.28 or later on Windows, the loading page never closes. Why? pgAdmin 4 v4.28 includes additional security features, one of which is intended to prevent security issues caused by Content Sniffing.

Unfortunately some Windows systems are mis-configured such that this causes Javascripts used by pgAdmin to fail to load. Opening the developer tools on your browser will show an error similar to this:

Refused to execute script from 'http://127.0.0.1:57313/static/vendor/require/require.min.js?ver=42800' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled.

(index):39 Uncaught ReferenceError: require is not defined at (index):39 This will occur when the value of the registry key at HKEY_CLASSES_ROOT.js\Content Type is set to text/plain. To resolve the issue, use the Registry Editor and reset the value of HKEY_CLASSES_ROOT\.js\Content Type to: text/javascript

Finally, restart the pgAdmin server.

Also, after changing registry, I had to kill `pgAdmin 4 Desktop Runtime` process by *Task Manager* and run pgAdmin again. — Megidd, Mar 02 '21 at 02:39

score 18 · Answer 2 · answered Jun 08 '18 at 18:09

18

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.

answered Jun 08 '18 at 18:09

Darrell Brogdon

6,843
9
47
62

This should be the accepted answer. There are a few process that open outside of the browser when PGAdmin4 starts. I'm betting you could also bookmark the web page that launches and just start from there. – Raydot Jun 18 '18 at 17:16
This should be the accepted answer. It solved the problem without downgrading. – Soerendip Sep 07 '18 at 23:43
killall pgadmin4 and rebooting it up fixed it for me – Vincent Tang Sep 10 '19 at 02:25
Hmm, `killall pgAdmin4` on Ubuntu says "pgAdmin4: no process found", so I guess my problem has a different cause. Thanks anyway. – Ryan Mar 26 '23 at 16:14
On Ubuntu 22.04, I needed to downgrade my Python: https://askubuntu.com/a/1461009/48214 – Ryan Mar 26 '23 at 16:24

score 6 · Accepted Answer · answered Jun 07 '17 at 14:39

6

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.

answered Jun 07 '17 at 14:39

svarog

9,477
4
61
77

3

This solution worked for me on Windows 10 64bit. It's worth noting that restarting the computer allowed pgAdmin4 to load, but strangely the next time I restarted my computer pgAdmin 4 was stuck in the eternal loading state once again. pgAdmin3 seems to be more reliable. – abagh0703 Jul 09 '17 at 17:13
1

This is not a solution, but a workaround. Abrahim's answer has a proper solution. – Ganesh Jadhav Nov 30 '20 at 09:00
At the time this was the only solution that allowed me to be productive so I proposed it, OP accepted it as best solution back then, pretty sure things have changed since than. – svarog Nov 30 '20 at 10:15
As mentioned before Abrahim's answer is the correct solution – Samyne Dec 01 '20 at 08:51

score 4 · Answer 4 · answered Dec 06 '20 at 20:20

as per Abrahim's suggestion, it worked fine for me in the environment. Windows 10, pgAdmin 4.28

"value of the registry key at HKEY_CLASSES_ROOT.js\Content Type is set to text/plain. To resolve the issue, use the Registry Editor and reset the value of HKEY_CLASSES_ROOT.js\Content Type to: text/javascript "

score 1 · Answer 5 · answered Aug 09 '17 at 18:02

1

I had this issue on Mac. I resolved it by:

Closing the instance of PgAdmin 3 AND PgAdmin4 (I had both open)
System Preferences -> Security & Privacy -> Allow apps downloaded from: Anywhere
Reopen PgAdmin4

answered Aug 09 '17 at 18:02

tytk

2,082
3
27
39

chhay lyheng · Answer 6 · 2019-02-07T07:28:35.380

1

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.

edited Feb 07 '19 at 07:28

answered Jan 31 '19 at 05:12

chhay lyheng

21
2

score 1 · Answer 7 · answered Jul 16 '20 at 02:33

1

For me, the postgresql server was set to start manual and it was not running in services, i started the service and it worked

answered Jul 16 '20 at 02:33

RRR

507
4
17

score 1 · Answer 8 · answered Aug 09 '20 at 07:26

1

Download pgAdmin from its website and install it separately from postgres.(Its works for me on Windows 10 - 64 Bit)

answered Aug 09 '20 at 07:26

ilhan

125
2
13

score 0 · Answer 9 · answered Apr 05 '17 at 05:49

0

Response from pgadmin-support mail group:

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.

answered Apr 05 '17 at 05:49

Murtuza Z

5,639
1
28
52

1

I removed pgAdmin using revo uninstall pro, then installed this test build and it didn't work (same error as before). – pedroth Apr 06 '17 at 08:54

score 0 · Answer 10 · answered Apr 12 '17 at 19:38

0

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

answered Apr 12 '17 at 19:38

Victor Castro

933
7
9

Henrique Lima · Answer 11 · 2020-02-01T01:48:38.360

0

I found a solution here pgAdmin 4 v3.1 How can I use another browser? (Win 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.

I think this is the correct way to use pgadmin4.

edited Feb 01 '20 at 01:48

answered Jan 31 '20 at 23:11

Henrique Lima

111
3
7

score 0 · Answer 12 · answered Dec 17 '20 at 04:15

0

Go to Services and restart PostgreSQL Server.

answered Dec 17 '20 at 04:15

Abishek Stephen

386
1
3
15

score 0 · Answer 13 · answered Jun 05 '23 at 19:06

If you happen to come here while trying to troubleshoot similar issue on mac, note that sometimes pgadmin setup done while installing postgres doesn't work. Uninstall pgadmin - go to postgres installation directory, click uninstall - uninstall selected app - pgadmin. Once the uninstall is complete. Download a fresh pgadmin. It worked for me.

Ref - https://dba.stackexchange.com/questions/327474/pgadmin-4-v-7-1-not-loading-after-trying-everything

One other possible solution can be - https://www.pgadmin.org/faq/#:~:text=then%20restart%20pgAdmin.-,On%20macOS%2C%20I%20get%20an%20error%20like%3A%20%22pgAdmin%204%20is%20damaged%20and%20cannot%20be%20opened%22,-This%20has%20been

pgAdmin won't start (eternal loading)

13 Answers13