Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

postgresql pgadmin keep loading forever

I have tried to install postgresql+ pgadmin multiple times. My environment is Window 10 and the postgresql version is 10.15 (postgresql-10.15-1-windows-x64.exe). The installation completed but when I run pgadmin, it just keep loading as attached.

enter image description here

And when I run powershell get-process, this is what I get: enter image description here

I tried to uninstall it and kill at the process and re-install again, but I still get the same issue.

like image 659
Steve Avatar asked Nov 18 '20 07:11

Steve


People also ask

Why is pgAdmin 4 so slow?

Programming languages are not made equal. Python is four times slower than languages like C++ or Java. This could explain that pgAdmin 4 is slow.

How do I force quit pgAdmin?

If you are using pgAdmin 4 on mac OS or Ubuntu, you can use system tool bar (at the top of the screen) icon for this. After you start pgAdmin server the icon with elephant head should appear. If you click it you will have an option Shut down server .

Why is pgAdmin not connecting to server?

If pgAdmin displays this message, there are two possible reasons for this: the database server isn't running - simply start it. the server isn't configured to accept TCP/IP requests on the address shown.

Why does the page never close when I launch pgadmin?

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 misconfigured such that this causes Javascripts used by pgAdmin to fail to load.

What is the total query time for a pgadmin query?

Total query runtime: 148 ms. 1 row retrieved. it also hangs on any operation: even right clicking on a table. Afterwise I connect via RDP and run the same query there in the same pgAdmin version which displays results immediately with query time: 32 ms.

Is there a way to restart the pgadmin server?

Restart the pgadmin server. You can do this by ending the pgadmin background task from the task manager. Simply amazing! Thank you :D This flips back with every update to Visual Studio 2019. So it may need to be done more than once. works for me. I wonder why the fix is so obscure though. :)

What information should I include in my post about pgadmin?

Try to include as much of the following information as possible: The version of pgAdmin you are running, and where you obtained it from. Whether you're running in server or desktop mode


4 Answers

I've had the same problem. The link here has the solution: https://www.pgadmin.org/faq/#12

The problem is that the value of the ContentType object in HKEY_CLASSES_ROOT / .js is set to text / plain. If you follow the steps below, your problem will be resolved.

  1. Open the Registry Editor (Run -> regedit)
  2. Find HKEY_CLASSES_ROOT\.js and change the ContentType value as text/javascript
  3. Restart the pgAdmin server

If you do not want to use it through the browser, I recommend you to try the desktop version as well. https://www.pgadmin.org/download/

like image 67
Volkan Barbaros Gurcan Avatar answered Oct 23 '22 01:10

Volkan Barbaros Gurcan


Me faced the same problem as well . The link here has the solution: https://www.pgadmin.org/faq/#12

The problem is that the value of the ContentType object in HKEY_CLASSES_ROOT / .js is set to text / plain. If you follow the steps below, your problem will be resolved.

Open the Registry Editor (Run -> regedit)

1.Find HKEY_CLASSES_ROOT.js

2.Change the ContentType value as text/javascript

3.Restart the pgAdmin by shutting down the previous server

It will surely work.

like image 28
Sreerag307 Avatar answered Oct 23 '22 00:10

Sreerag307


I had trouble finding the key and change the ContentType to text/javascript

Actually the full path in regedit is Computer\HKEY_CLASSES_ROOT\.js

like image 1
A_X Avatar answered Oct 23 '22 01:10

A_X


To anyone that couldn't find the ContentType in Computer\HKEY_CLASSES_ROOT.js and there is only the (Default), just create a new one.

"New -> String Value"

I had to set the name as Content Type because ContentType didn't made any difference.

like image 1
Thiago Deodato Avatar answered Oct 23 '22 00:10

Thiago Deodato