PostgreSQL "connection terminated" - quite frustrated :/

Hey, JP.

If your DB is in a VPS, you should change your configuration to that IP address.

My DB is running in a VPS, so my proxy is running at http://MY_IP:2899 (I see “Database proxy my-db-name (postgres) running at http://MY_IP:2899” in my server) and my database connection string is postgresql://user:password@127.0.0.1:5432/my-db-name (I can confirm that this works by running this from the server psql <MY CONNECTION STRING>).

If I go to http://MY_IP:2899 on the browser I see a 401 error (as I should), but when I run the “Test connection” from Observable, I don’t see any connection attempt in the log, just this error “Connection terminated unexpectedly”:

@visnup Any suggestions on how to debug this?

1 Like