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
tascofyvasswm...@ec2-27-837-167-90.eu-west-1.compute.amazonaws.com on
dbname "dascn90er7ghpl"
)
Any pointers would be hugely appreciated!
Thanks,
Izaak
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
