AWS remote connection using 'pg' gem

[Henry]

I'm trying to connect to postgres running on a AWS from a rails app. Can anyone point me in the direction to achieve this?

[Henry]

just tried

conn = PGconn.connect( 'ec2-xx-xx-xx-xx.compute-xx.amazonaws.com', 5432, "", "", "dbname", "ubuntu", "" )

[Michael Granger]

On Tuesday, October 29, 2013 10:53:25 PM UTC-7, Henry wrote:

just tried

conn = PGconn.connect( 'ec2-xx-xx-xx-xx.compute-xx.amazonaws.com', 5432, "", "", "dbname", "ubuntu", "" )

...and what happened vs. what you expected to happen?

 

[Henry]

I figured it out:

conn = PG::Connection.new( 'ec2-xx-xx-xx-xx.compute-xx.amazonaws.com', 5432, "", "", "dbname", "postgres", "" )

works. I was using the wrong name for the user.

On Tuesday, October 29, 2013 10:20:39 PM UTC-7, Henry wrote: