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.
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.
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.
This was an error in 1.0.
1.1 and 1.2 have corrected this.
Please upgrade to latest version pgAdmin4(1.3), This issue has been resolved now.
https://www.pgadmin.org/download/
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