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
Are my connection settings in psqlODBC correct?
Data Source: PostgreSQL30
Database: database
Server: localhost
Port: 5432
I didn’t enter credentials (un/pw) since I’m connecting to localhost - is that a correct assumption?
Keith Yanase wrote:
> The server only allows SSH tunneling. I’m able to establish the SSH tunnel with the command: ssh jupyter
> but how do I tell psqlODBC to connect to that port?
Run "ssh -L bindaddress:localport:remoteserver:remoteport sshserver", where
"remoteserver" is the host name you want to connect to, from the point of
view of the SSH server.
So run "ssh -L localhost:5432:localhost:5432 jupyter", and tell psqlODBC to
connect to localhost:5432.
Regards,
Clemens