Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pgAdmin 4 Query Tool not connecting to database

Tags:

pgadmin-4

I am trying to query a remote database that I am connected to, however am having issues 'connecting' to the database with the Query Tool. The Query Tool opens, however the 'plug' icon stays red and doesn't seem to connect to the database (see picture below).

pgadmin query tool screenshot

I'm not sure if that is the best way to describe it, however hopefully attached picture makes sense.

Is there a reason that this is occurring? I have left it to load overnight, etc. in case it is just waiting to connect with remote database but it still does not connect.

Thanks in advance

like image 334
bellingc Avatar asked Oct 23 '18 07:10

bellingc


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. The Query Tool allows you to: Issue ad-hoc SQL queries.

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.

How do you connect to a database in pgAdmin?

In the Create - Server dialog box, type a name on the General tab to identify the server in pgAdmin. On the Connection tab, type the following information from your DB instance: For Host, type the endpoint, for example mypostgresql.c6c8dntfzzhgv0.us-east-2.rds.amazonaws.com . For Port, type the assigned port.


1 Answers

I had the same problem for months. But I found that the issue would be resolved when we download and install pgAdmin 4 v4.2 .If a VPN is needed to connect to your remote database, makes sure that it works fine in your computer.

The download link is: https://www.pgadmin.org/download/

like image 171
Sampath kumar Avatar answered Oct 25 '22 20:10

Sampath kumar