Continuing the discussion from connect to postgre db through ssh tunnel by r:
Hello yes I use RPostgres package for the database connectin but the problem is about making an ssh tunnel,ı found something like that
ssh -p Port -L LocalPort:IP:RemotePort servername"
but I couldn't understand the parameters,
and on the other hand ı can already connect to the database by a vpn ssh tunnel outside of R.But I need to connect it by r.
I run the below codes but of course it didn't work
[10/1/2019 9:15 PM]
myssh<-"ssh -f merve_sarac@ip -L port:localhost:22 -N"
system(myssh)
Connect to DB
drv <- dbDriver("PostgreSQL")
conn <- dbConnect(
drv,
host = "", user = "",
password = "", dbname = ""
)