
Output from sudo netstat -ltpn | grep 5432 Sudo ssh -N -vvv -L 5433:localhost:5432 last few debug lines are as follows: debug1: Local forwarding listening on 127.0.0.1 port 5433.ĭebug3: ssh_packet_set_tos: set IP_TOS 0x10ĭebug1: client_input_global_request: rtype want_reply 0 Per excellent advice, I ran the following: I also tried substituting 127.0.0.1 forlocalhost with no success.Īny advice would be appreciated SSH tunnels and the like are not something I am familiar with. Max_connections = 100 # (change requires restart) # defaults to 'localhost' use '*' for all Listen_addresses = '*' # what IP address(es) to listen on I changed "listen_addresses" in nf to * # - Connection Settings. # "local" is for Unix domain socket connections only To my knowledge, my pg_hba.conf (on the remote server) is the default: # Database administrative login by Unix domain socket Is the server running on host "localhost" (127.0.0.1) and accepting However, I receive the following error: psql: could not connect to server: Connection refused

As this is not something I have attempted before, I referenced this, this, and this.Īfter looking over the articles, I ran the following on my client/local machine: ssh -L 5433:localhost:5432 I tried to connect: psql -h localhost -p 5433 postgres

I am attempting to create an SSH tunnel from my client to the remote database. I am, for the first time, attempting to set up an application on a remote/cloud VPS (I am using Digital Ocean if it matters).
