[R] Error using RPostgreSQL

[Izaak Rogan]

Hi,

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(
          drv,
          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!

Thanks,
Izaak