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.
And when I run powershell get-process
, this is what I get:
I tried to uninstall it and kill at the process and re-install again, but I still get the same issue.
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.
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 .
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.
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.
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.
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. :)
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
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.
HKEY_CLASSES_ROOT\.js
and change the ContentType value as text/javascript
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/
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.
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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With