Cant connect R and PostgreSQL throught Putty -

-

i have problem integration postgresql , r. unload outputs sql queries .txt file , download em r using read.table() function. need outputs queries directly in r. know sql? it's postgresql, use putty connect db know such information putty connection as

  1. host name(or ip adress)
  2. port
  3. saved session ='dbcenter'
  4. connectiontype = ssh
  5. key -- file .ppk extension
  6. passphrase key

also, before writing queries, choose in opened window

  1. region
  2. databases

this full information know putty , have no idea how write queries directly in r script. tried rpostgresql package, no success.

can me?

firstly, make sure can connect remote db without r, example, using pgadmin3 or psql (see link1 , link2 more idea pgadmin/psql/remote/port forwarding).

then, try along these lines:

dbname <- "myname"; dbuser <- "myname"; dbpass <- "iwillnottell"; dbhost <- "remotehostname"; dbport <- 5432;

if remote host withing same local network (ie, local host myhost.host.edu), then, following should work well:

dbhost <- "remote"  library(rpostgresql) drv <- dbdriver("postgresql") con <- dbconnect(drv, host=dbhost, port=dbport, dbname=dbname,                  user=dbuser, password=dbpass) query = 'select * tablename' dbgetquery(con, query) sqldata<-dbgetquery(con, query) summary(sqldata)

sqldata dataframe

the important thing firewall , access db. suggest, using pgadmin3 make sure can connect server.

if local firewall not allow connection postgresql server port you'll need use ssh tunneling - connection can pretty slow depending on how remote remote host is. example:

assuming sever allows listens "localhost" (this wrt server), then:

ssh -l 22222:localhost:5432 myname@remotehostname

will forward 22222 port on client remote's 5432 port. again, use pgadmin3 @ point make can connect.

then set

dbhost <- "localhost"; dbport <- "22222"

and use same dbconnect call. once dbconnect call successfull sql results in r local


Comments

Post a Comment

Popular posts from this blog

c# - Where does the .ToList() go in LINQ query result -

-
when getting data populate data grid, have pulled data, made list , mapped model, this: public list<person> getpeople() { var data = _db.person.tolist(); list<person> people = new list<person>(); foreach (var item in data) { person person = new person() { personid = item.personid, firstname = item.firstname, lastname = item.lastname }; people.add(person); } return people; } this works fine, in interest of writing less code discovered .select method , (what think is) anonymous type. have: public list<person> getpeople() { return _db.person.select(d => new person { personid = item.personid, firstname = item.firstname, lastname = item.lastname }).tolist(); } though not easy read, works fine too. there preference either way? ...
Read more

Listeners to visualise results of load test in JMeter -

-
i want run load test in non-gui mode , save results in .csv file. (i have not modified .properties files, standard information saved) i plan load file , visualise results jmeter’s listeners. which listeners suited purpose? should avoid @ cost, might cause me misinterpret information? (e.g. in view results tree response data empty have - - not saved this. however, there has in fact been response. if saw listener might think there hasn’t been one. since want avoid this, listeners have gain information needed .csv file.) i’d know both jmeter listeners plugins. if running test in non-ui mode ideally should disable listeners in script. use '-l' option store test results .jtl extension. can later open jtl file jmeter. aggregate report or summary report should summarize test results , response time , throughput. if want plot graphs see trends on test duration can use http://jmeter-plugins.org/#/ standard , lib set. i suggest following listeners: response ...
Read more

android - CollapsingToolbarLayout: position the ExpandedText programmatically -

-
i using new android support design view collapsingtoolbarlayout. have need position expandedtitle programmatically. actually way set position expandedtitle in .xml file (example here: https://goo.gl/l5h5fc ) there no public api set text position programmatically , fields private . do know if it's possible without reflection or 'hacky' tricks? i have solved problem exposing properties via reflection ( https://gist.github.com/fpezzato/8e7d45112883dbbc5ffb ), works don't use trick in production code. @google: please no more private or final stuff! :)
Read more