Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't query data on pgAdmin 4 but it works using psql and Python

I have created a postgresql database on rds and I can connect and query it using psql on terminal or sqlalchemy on Python. When using pgAdmin4 I can't query or visualize the data but can create/alter tables, import data, ...

I have also tried connecting it to Metabase and DBeaver but the connection times out.

Any ideas why this is happening?

I have also connected the database using pgAdmin3 and was able to visualize the data and query it, but since I am using postgresql 11.4 it is not fully supported by pgAdmin3.

When I open the query tool on pgAdmin 4 I get this message:

could not send data to server. Socket is not connected could not send startup packet: Socket is not connected.

like image 389
ufru Avatar asked Sep 20 '19 19:09

ufru


People also ask

When using PostgreSQL What is the difference between using psql and pgAdmin?

The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities. The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines.

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.


1 Answers

Helped me: changing 'localhost' in connection settings to '127.0.0.1'

like image 170
psmagin Avatar answered Oct 18 '22 20:10

psmagin