I don't use PostGreSQL, but I strongly suspect that you would have this problem
using other drivers as well, so pick any method described in the PostGreSQL
documentation to verify that you can reach the server and your dbname from the
machine where you are running R. Note that where you are connecting from may be
just as important as where the server is, and configuration of any of the
database, the virtual OS or the AWS environment may prevent connections for
security reasons.
If you have confirmed all this is working outside of R, then you should
probably ask on R-sig-db for R-specific help.
--
Sent from my phone. Please excuse my brevity.
On April 21, 2016 8:49:49 AM PDT, Izaak Rogan <izaakro...@gmail.com> wrote:
>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.
[[alternative HTML version deleted]]
______________________________________________
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.
