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://www.rforge.net/rjdbc/

http://ryepup.unwashedmeme.com/blog/2010/11/17/working-with-r-postgresql-ssl-and-mssql/

hope helps out.


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -