The PostgreSQL server runs on amazon cloud server (RDS). Jupyter hosts the SSH tunnel.
I tried the following:
ssh -L localhost:5432:127.0.01:5432 jupyter
Still getting this error when attempting to connect to localhost:5432 in psqlODBC.
channel 3: open failed: connect failed: Connection refused
The database resides in amazon, which is accessed on my computer through an SSH tunnel hosted on jupyter.
I don't have access to the database configurations, but is there a way I can find out what the database is configured to listen on?
Keith Yanase wrote:
> I ran the command and when I tel psqlODBC to connect to localhost:5432 I get this message in the terminal:
> Channel 3: open failed: connect failed: connection refused
Does the PostgreSQL server run on the "jupyter" host?
Is the database configured to listen on "localhost" or "127.0.0.1"?
In the latter case, use "ssh -L localhost:5432:127.0.0.1:5432 jupyter".
Regards,
Clemens