[R] Error using RPostgreSQL

[Jeff Newmiller]

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 <izaakrogan at 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
>tascofyvasswmblc at ec2-27-837-167-90.eu-west-1.compute.amazonaws.com on
>dbname "dascn90er7ghpl"
>)
>
>Any pointers would be hugely appreciated!
>
>Thanks,
>Izaak
>
>______________________________________________
>R-help at 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]]