[R] Error using RPostgreSQL

Izaak Rogan izaakrogan at gmail.com
Thu Apr 21 17:49:49 CEST 2016


I'm having trouble connecting to my postgreSQL db on Heroku(Amazon)
using RPostgreSQL.

I've looked through GitHub for people doing the same thing. There are
quite a few examples and all look similar to the below:

drv <- dbDriver("PostgreSQL")

con <- dbConnect(
          dbname = "dadqn30er7ghpl",
          host = "ec2-27-837-167-90.eu-west-1.compute.amazonaws.com",
          port = 5432,
          user = "tascofyvasswmblc",
          password = XXXXXX'

I'm getting the error:

Error in postgresqlNewConnection(drv, ...) :
  RS-DBI driver: (could not connect
tascofyvasswmblc at ec2-27-837-167-90.eu-west-1.compute.amazonaws.com on
dbname "dascn90er7ghpl"

Any pointers would be hugely appreciated!


More information about the R-help mailing list