Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pgadmin4 query tool always shows message not connected

Tags:

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.

like image 267
Richard Avatar asked Sep 05 '16 11:09

Richard


People also ask

How do I enable query Tool in pgAdmin 4?

You can access the Query Tool via the Query Tool menu option on the Tools menu, or through the context menu of select nodes of the Browser tree control.

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.


2 Answers

This was an error in 1.0.

1.1 and 1.2 have corrected this.

like image 67
Holger Jakobs Avatar answered Dec 18 '22 17:12

Holger Jakobs


Please upgrade to latest version pgAdmin4(1.3), This issue has been resolved now.

https://www.pgadmin.org/download/

like image 39
Murtuza Z Avatar answered Dec 18 '22 17:12

Murtuza Z