![postgres ssh tunnel postgres ssh tunnel](https://i.stack.imgur.com/T5Y4t.png)
The command that I am using is the following: ssh -i "C:/path/to/ssh/key" -L 5555:127.0.0.1:1234 this connection is open, I of course can access the DO Server. I have managed to connect to the DO Server from my PC using the CMD application. I logged in to the database using the following parameters: With the configuration mentioned above, I was able to connect PgAdmin to the Postgresql database in the DO Server. Also, the DO Server is already configured to allow SSH connections (example ip: 123.456.789.01 and port:1234). PEM key pair (I will refer to the passphrase for the private key as 'passp') private key and enabled the public key in the Digital Ocean Server (DO Server from now on). On the Digital Ocean Server I have Ubuntu 20.04.1, postgresql 12+214ubuntu0.1, openssh-server 1:8.2p1-4ubuntu0.2įirst of all, I have already generated a. I have installed PostgreSQL 13, R 4.0.3, OpenSSH Server and OpenSSHD Client (for the Open SSH I am using the standard Windows versions).
#Postgres ssh tunnel windows 10#
On my local computer, I am using Windows 10 圆4. I am new to the SSH Connections, specially using R.
![postgres ssh tunnel postgres ssh tunnel](https://www.tcien.com/wp-content/uploads/2020/04/pgadmin_screen12-300x134.png)
I am trying to connect an RStudio Session to a PostgreSQL database which is on a server (Digital Ocean) through a SSH Tunnel.