r - RPostGreSQL with maintenance-db -
i'm trying connect postgre database using rpostgresql. here's code :
drv <- dbdriver("postgresql") con <- dbconnect(drv, dbname='dbname', host='10.10.111.111', port='1983',user='user' password='pass')
i able connect database using pgadmin same parameters, difference that, in pgadmin, have "maintenance-db" line can't fill in dbconnect. tried put maintenance-db in dbname, doesn't work. noticed now, no db expert, don't know "maintenance-db" thing... appreciated !
had same problem database hosted on heroku. heroku using maintenance-db , forces ssl usage - not supported rpostgresql. had switch rjdbc worked well
http://ryepup.unwashedmeme.com/blog/2010/11/17/working-with-r-postgresql-ssl-and-mssql/
hope helps out.
Comments
Post a Comment