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:

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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 "

Answer 5

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

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

Answer 6

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.

Answer 7

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

Answer 8

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.

Answer 9

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

Answer 10

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.

Answer 11

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

Answer 12

Go to Services and restart PostgreSQL Server.