pgadmin4 : postgresql application server could not be contacted.

Postgresql Problem Overview

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_distro.py, and delete the files in Roaming folder,i tried standalone pgadmin4 installation, but no success.However, in my local machine i am able to access the server using psql.exe and log as as superuser (postgres user). Can you please suggest any possible solutions to starting/running pgadmin4 ? Thank you.

Postgresql Solutions

Solution 1 - Postgresql

I found the same issue when upgrading to pgAdmin 4 (v1.6). On Windows I found that clearing out the content inside C:\Users\%USERNAME%\AppData\Roaming\pgAdmin\sessions folder fixed the issue for me. I believe it was attempting to use the sessions from the prior version and was failing. I know the question was marked as answered, but downgrading may not always be an option.

Note: AppData\Roaming\pgAdmin is a hidden folder.

Solution 2 - Postgresql

We got the same issue. so no any change in the file. but start pgAdmin 4 using administrator.

The following step.

right click pgAdmin 4 icon
select "Run As Administrator"

Solution 3 - Postgresql

I had the same issue on Windows 10, with a new installation of PostgreSQL 10.

I solved it by including the path C:\PostgreSQL\10\bin ({your path to postgresql}\bin) to system environment variables.

To access environment variables: Control Panel > System and security > System or right click on PC, then > Advance system settings > Environment variables > System variables > Path > Edit.

Solution 4 - Postgresql

It seems in most of the cases Postgres trying to use information from previous sessions to find/connect the server and failing. Clearing out the previous session info helped me, it is a combination of 2 already mentioned answers above:

Navigate to Postgres session's folder C:\Users\YourUsernameOrAdmin\AppData\Roaming\pgAdmin\sessions
Delete all the data from this folder.
Start PgAdmin in administrator mode.

Cheers!

Solution 5 - Postgresql

What finally worked was downgrading to pgadminIII-v.1.22:

Solution 6 - Postgresql

I've been dealing with this for awhile (frustrating). So much that I have instructions on my desktop consolidating all of these ideas. Here is my magic combination to the solution:

Delete from App Data C:\Users%USERNAME%\AppData\Roaming\pgAdmin
Add to Path Variables C:\Program Files\PostgreSQL\9.6\bin (I actually added it to both user and system)
Right click and start as admin.

You don't have to do this every time but when it gets out of wack try these steps.

Solution 7 - Postgresql

if you are using Mac OS X here is a fix: Open terminal and run this command

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log restart

and for other OS just restart your Postgresql server, it will solve

Then start pgAdmin4, it will start as normal

Share or comment if saved someone

Solution 8 - Postgresql

I had same issue on windows. I had v1.6 installed as well as v2.0. Uninstalling v1.6 allowed me to login.

Solution 9 - Postgresql

I had the same problem, but running it as an admin worked.

Solution 10 - Postgresql

Deleting the contents of C:\Users\%USERNAME%\AppData\Roaming\pgAdmin directory worked for me!

Solution 11 - Postgresql

Have you recently installed a new version of pgAdmin ?

This issue (and the misleading message) is simply due to the fact that old versions of pgAdmin are unable to read the settings saved by a newer version of pgAdmin !

Make sure you're starting the right version of pgAdmin (your shortcuts are likely to point to the old version !) and/or uninstall the old version: the upgrade wizard doesn't do it for you !

Solution 12 - Postgresql

Deleting contents of folder C:\Users\User_Name\AppData\Roaming\pgAdmin\sessions helped me, I was able to start and load the pgAdmin server

Solution 13 - Postgresql

I had the same issue on the macosx and I renamed .pgadmin (in /users/costa) to .pgadminx and I was able to start pgAdmin4.

Solution 14 - Postgresql

In Windows Just go to this path and clear it ,that works !!

> C:\Users%USERNAME%\AppData\Roaming\pgAdmin

Solution 15 - Postgresql

I was able to solve the problem by changing the pgAdmin web interface port.

I believe this problem occurred on my computer because I have several other services consuming webs ports like qBittorrent, IDEJetbrains, etc.

Right-clicking on the pgAdmin logo near the clock is possible to configure it.

Solution 16 - Postgresql

I Fixed it in windows 10 just running pgAdmin 4 as Run as Administrator .

Solution 17 - Postgresql

If you use older postgresql version like 9.x and its services is running,PgAdmin 4 confused which server is base database.

So stop the service older version or new one.Run PgAdmin 4 as Administrator

Its worked for me

Solution 18 - Postgresql

I use the cmd prompt on Windows 10 with psql postgres postgres.

Then I launch pgAdmin4 and it works.

Solution 19 - Postgresql

I had this problem with pgadmin4 v2.1 on linux fedora 27

Solved by installing a missing dependency: python3-flask-babelex

Solution 20 - Postgresql

This is often a firewall problem. The firewall log then shows dropped packets between 127.0.0.1: and 127.0.0.1:, where the latter is the port shown in the Browser to get no connection with. This means, that the connection between pgAdmin client (high_port_1) and pgAdmin server (high_port_2) is blocked. Check your firewall log and if you find dropped packets like described, adapt your firewall settings accordingly.

Solution 21 - Postgresql

Just click on that pgadmin 4 icon and run as administrator. Allow the access permissions. It will start locally.

Solution 22 - Postgresql

If none of the methods help try checking your system and user environments PATH and PYTHONPATH variables.

I was getting this error due to my PATH variable was pointing to different Python installation (which comes from ArcGIS Desktop).

After removing path to my Python installation from PATH variable and completely removing PYTHONPATH variable, I got it working!

Keep in mind that python command will not be available from command line if you remove it from PATH.

Solution 23 - Postgresql

Got this issue after I upgraded PostgreSQL 9.4 to 9.6. The 9.4 binary package had PgAdmin 3 while 9.6 came with PgAdmin 4. I resolved it after a clean installation (I completely uninstalled and reinstalled) of PostgreSQL.

However, under different circumstances, you could try running the pgAdmin 4 application as an Administrator. This should fix the error.

Solution 24 - Postgresql

downloaded pgadmin 4 v2.0 and install it no problem atm on force installation. try it. that was solution for me.

Solution 25 - Postgresql

I need to add this here because I've had several issues with this message. If you have recently upgraded to High Sierra you will find the latest (pgadmin 4.20) will keep appearing with the message "Application Server Could Not be Contacted". What this actually means on Macs is that python was unable to configure your environment in ~/.pgadmin

This directory stores all the things you setup and configure and even logs of what was ran on your user copy usage of pgadmin.

The way to fix this issue on High Sierra is down to sqlite3. If you look in that directory you'll see everything is stored in sqlite3 files.

When version 4.20 of pgadmin was released it was shipped with a version later than sqlite3.19 and the problem arises because High Sierra is shipped with sqlite3.19, so to fix this issue, you need to replace the old version of sqlite3 with the latest on your packager.

Now be aware, MacosX+ all use sqlite to store details for the majority of apps on your mac, so you'll need to make sure you do not just wipe the old version but you'll have to have both versions co-existing together in harmony to avoid anything major occurring on your mac.

download brew https://brew.sh/
update brew and upgrade brew to make sure it's up-to-date
brew install sqlite3
mv /usr/bin/sqlite3 /usr/bin/sqlite3.os
ln -s /usr/local/Cellar/sqlite/3.21.0/bin/sqlite3 /usr/bin/sqlite3
/usr/bin/sqlite3 -version (check version is later than 3.19)

You can now proceed to open up pgadmin as normal

Solution 26 - Postgresql

For my case in Windows 10 for postgresql 10 version, it worked by changing SERVER_MODE to False in config_distro.py placed in web folder, as per these configuration settings: https://www.pgadmin.org/docs/pgadmin4/dev/desktop_deployment.html.

There are other settings mentioned in this answer (https://superuser.com/a/1131964) regarding python but I just changed SERVER_MODE and it worked.

Solution 27 - Postgresql

Kill it in Windows Task Manager and then try again. It seems that there is some sort of a problem when accessing the server from different applications.

Solution 28 - Postgresql

As for me on windows 2012r2 it's start to work only after I reinstall pgAdmin 4 to folder c:\pgAdmin4. With out spaces and any special chars. And all so I give full permission to this folder in NTFS.

Solution 29 - Postgresql

It worked for me after installing python2.7 for pgAdmin 4 v2

Solution 30 - Postgresql

Happens mostly when you have multiple versions of pgadmin installed or while trying to upgrade. Even I tried everything from killing the "running PID on port 5432" to "changing the server mode". In my case I uninstall postgres and re-install it again on different port(5433). Later, I opened it through cmd(right click on cmd and select "run cmd as an Administrator").

Solution 31 - Postgresql

I ran into this issue as well. Windows 10. I had older version of pgAdmin 4 (1.6) and 2.0. I guess both are older now.

In any case a complete uninstall of both versions and a reinstall of 2.0 worked.

Solution 32 - Postgresql

A variety of reasons attribute to the failure boot of pgAdmin 4. The reason to my situation is that my Windows system language is not English or utf-8 related. Changing the system locale to English solved the starting issue.

Solution 33 - Postgresql

Last resort HKEY_CURRENT_USER\Software\pgadmin\pgadmin4 export/delete you know what to do here :)

Solution 34 - Postgresql

I had a hard time getting pgadmin4 to run on Windows 10 because of having multiple pgadmin4's around, possibly having installed other python versions.

My first suggestion is:

The "application server" is not Postgres itself, but a python program launched by pgadmin4.
If like me you just invoke the Windows Start menu and start typing the name of the program you want to run (p g a d m i n ...), take a moment to right-click on the results, open the file location, right-click on the executable and look at its properties to make sure it's the version you think you're running.
If the version does not match your expectations, open the Start Menu and look carefully for the version you just installed.

Case 1: One of the pgadmin versions I had trouble was a global installation of pgadmin4 version 3.5 in c:\Program Files\PostgreSQL\11\pgAdmin 4. What worked for me in this case was making sure that its python virtual environment was setup properly.

Go to the c:\Program Files\PostgreSQL\11\pgAdmin 4\venv\Scripts directory and edit activate.bat. Make sure the path in set "VIRTUAL_ENV=... is actually c:\Program Files\PostgreSQL\11\pgAdmin 4\venv (or something that makes sense)
Open a command prompt and go to the c:\Program Files\PostgreSQL\11\pgAdmin 4 directory
Activate the python environment by typing .\venv\Scripts\activate.bat; the command prompt should change
At this point, I could launch pgadmin4 manually from the command prompt using .\bin\pgAdmin4.exe
This version lets you right-click on its icon in the system tray, and you get a menu that lets you tweak a few settings and look for its logs.

Case 2: During troubleshooting, I also installed a user specific pgadmin4 version 0.54.1 and it didn't work either. This one lives in c:\users\{your username}\AppData\Local\Programs\pgAdmin 4\v5\runtime\pgAdmin4.exe.

This version displays a configuration button when it fails to run.
What worked for me here was running it as administrator and increasing the wait from 90 seconds to 2 minutes.

Solution 35 - Postgresql

I had this issue after installing Postgres 13 on a windows 10 machine where already i had postgres 11.

After uninstalling all and reinstall 13 only I still had the problem.

I finally managed in his way:

uninstall postgres from control panel /uninstall applications choosing the option "uninstall components" and choosing "pgadmin" ad component to uninstall
downloaded pgadmin installer from pgadmin.org
installed pgagdmin
from the pgadmin preferences in the binarypath i put C:\Program Files\PostgreSQL\13\bin

This solved the issue for me.

Solution 36 - Postgresql

You should downgrade to https://ftp.postgresql.org/pub/pgadmin/pgadmin3/v1.22.2/win32/pgadmin3-1.22.2.zip">pgadmin3</a>;. It Worked for me on windows 10.1 with postrgreSQL 9.6.

Solution 37 - Postgresql

Deleting everything from this (C:\Users\YourUsernameOrAdmin\AppData\Roaming\pgAdmin) folder helped me launching pgAdmin4 server again

I am running pgAdmin4 v4.27 now. After I upgraded to pgAdmin4 v4.28 the problem started i.e. the server was not starting. I tried many ways including changing the content type of .js to test/javascript from text/plain, it did not work. Finally deleting all contents from C:\Users\YourUsernameOrAdmin\AppData\Roaming\pgAdmin helped me

Solution 38 - Postgresql

try this

I encountered the same problem and activated the setup file, it created a database, and was restarting again

sudo /usr/pgadmin4/bin/setup-web.sh

Content Type	Original Author	Original Content on Stackoverflow
Question	Kaleab Woldemariam	View Question on Stackoverflow
Solution 1 - Postgresql	icvader	View Answer on Stackoverflow
Solution 2 - Postgresql	Hardik	View Answer on Stackoverflow
Solution 3 - Postgresql	Magdalena	View Answer on Stackoverflow
Solution 4 - Postgresql	Shri	View Answer on Stackoverflow
Solution 5 - Postgresql	Kaleab Woldemariam	View Answer on Stackoverflow
Solution 6 - Postgresql	Dizzy	View Answer on Stackoverflow
Solution 7 - Postgresql	Joseph Daudi	View Answer on Stackoverflow
Solution 8 - Postgresql	user174487	View Answer on Stackoverflow
Solution 9 - Postgresql	kamal09	View Answer on Stackoverflow
Solution 10 - Postgresql	Akshata Dabade	View Answer on Stackoverflow
Solution 11 - Postgresql	Daniel	View Answer on Stackoverflow
Solution 12 - Postgresql	Vinod Kumar Gupta	View Answer on Stackoverflow
Solution 13 - Postgresql	costa	View Answer on Stackoverflow
Solution 14 - Postgresql	Akitha_MJ	View Answer on Stackoverflow
Solution 15 - Postgresql	Wilson Tamarozzi	View Answer on Stackoverflow
Solution 16 - Postgresql	Nayeem Azad	View Answer on Stackoverflow
Solution 17 - Postgresql	ahmeticat	View Answer on Stackoverflow
Solution 18 - Postgresql	Asma	View Answer on Stackoverflow
Solution 19 - Postgresql	Jose Miguel Perez	View Answer on Stackoverflow
Solution 20 - Postgresql	Balin	View Answer on Stackoverflow
Solution 21 - Postgresql	A_jain2310	View Answer on Stackoverflow
Solution 22 - Postgresql	Ingenium	View Answer on Stackoverflow
Solution 23 - Postgresql	Samuel Mwamburi	View Answer on Stackoverflow
Solution 24 - Postgresql	gofret	View Answer on Stackoverflow
Solution 25 - Postgresql	EamonS	View Answer on Stackoverflow
Solution 26 - Postgresql	Umair Malhi	View Answer on Stackoverflow
Solution 27 - Postgresql	Vitaliy Terziev	View Answer on Stackoverflow
Solution 28 - Postgresql	Denis Eltsov	View Answer on Stackoverflow
Solution 29 - Postgresql	User4567	View Answer on Stackoverflow
Solution 30 - Postgresql	daemonThread	View Answer on Stackoverflow
Solution 31 - Postgresql	Michael P. Scott	View Answer on Stackoverflow
Solution 32 - Postgresql	user12949097	View Answer on Stackoverflow
Solution 33 - Postgresql	CodeM7	View Answer on Stackoverflow
Solution 34 - Postgresql	Luis	View Answer on Stackoverflow
Solution 35 - Postgresql	UnDiUdin	View Answer on Stackoverflow
Solution 36 - Postgresql	gxet4n	View Answer on Stackoverflow
Solution 37 - Postgresql	Vinod Kumar Gupta	View Answer on Stackoverflow
Solution 38 - Postgresql	Ammar Abdul Wadood	View Answer on Stackoverflow