Re: [R] Error using RPostgreSQL

2016-04-22 Thread Tom Wright
On heroku the database uri is stored in an environment variable. > db_uri = Sys.getenv(''DATABASE_URL') I'm not sure if you can use that directly or if you will need to parse it for username, password etc. On Thu, 2016-04-21 at 16:49 +0100, Izaak Rogan wrote: > Hi, > > I'm having trouble connec

Re: [R] Error using RPostgreSQL

2016-04-22 Thread 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 conn