Using flyctl proxy 5432 -a myapp-db, I am able to connect to the database using pgAdmin (I also needed to disable SSL). I am able to see the databases and tables, however I am unable to do any query on any table, with the error “could not receive data from server: Socket is not connected (0x00002749/10057)”. Anyone knows what’s going on?
I figured it out. Needed to change the host in pgAdmin from localhost to 127.0.0.1.
4 Likes
Thank you. I had the same error and this solves it.