pgadmin4 query tool always shows message not connected

postgresql pgadmin-4
Richard picture Richard · Sep 5, 2016 · Viewed 9k times · Source

Q: How can I diagnose and correct problems with the Query tool connection.

Using pgAdmin4 1.0-rc1 to connect to a local host "PostgreSQL 9.5.3, compiled by Visual C++ build 18..."

In the browser pane I can connect and drill down to my schema. I use the context menu to select 'Query tool'. The editor shows the correct database@host:port in the editor header bar.

When I execute this sample query select 1 as first;

I get the message tab showing "Not connected to the server or the connection to the server has been closed.

instead of a simple grid showing first 1

Same message shows for any query, and the time it takes to come back with the message seems to be too long, especially since I'm using a localhost.

The same query works fine in phpPgAdmin.

Answer

Holger Jakobs picture Holger Jakobs · Mar 9, 2017

This was an error in 1.0.

1.1 and 1.2 have corrected this.

Related questions

pgadmin4 : postgresql application server could not be contacted.

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_…

Read More
FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any …

Read More
pgAdmin won't start (eternal loading)

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 …

Read More