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).
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
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.
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.
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.
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/
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