8

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.

ufru
  • 89
  • 1
  • 3
  • 1
    Are you running this locally? Is it possible that once client is using a unix socket while another is using tcp? – g_bor Sep 20 '19 at 20:10
  • @g_bor I am running it locally, only the database is in aws... – ufru Sep 20 '19 at 20:31
  • This might help: https://stackoverflow.com/questions/54311978/aws-rds-and-pgadmin4-unable-to-connect-to-server-could-not-connect-to-server – g_bor Sep 20 '19 at 20:37
  • If the above solves your problem, mark it as a duplicate please. – g_bor Sep 20 '19 at 20:38
  • @g_bor thanks, but it does not resolve my problem, since I can connect to the database, I just can't query it... – ufru Sep 20 '19 at 20:43

2 Answers2

44

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

psmagin
  • 1,000
  • 2
  • 9
  • 17
0

Disconnecting from server, Changing the connection -Host to localhost under properties, fixed it for me, running PgAdmin 4 in windows 11 connecting to PgSQl in WSL2

KrishnaKumar Velayudham
  • 1