title: Connecting to RDS Postgres from remote machine
body: <p>I have configured an RDS Postgres micro instance for testing but am having problem connecting. I have created a security group and allow all hosts (0.0.0.0/0) by default to port 5432 but for some reason I am not able to connect. I tried connecting to the port 5432 on the machine but it appears to be closed. Any ideas? I have verified that the security group is using the correct security group.</p>
  
  <p>This is my configuration</p>
  
  <pre><code>TCP
  Port (Service)  Source  Action
  5432    0.0.0.0/0   Delete
  </code></pre>
  
  <p>Here is how I am trying to connect to the rds service</p>
  
  <pre><code>psql -p 5432 -h example.cs945smhrv09.us-west-2.rds.amazonaws.com -U example example
  </code></pre>
  
  <p><strong>UPDATE</strong></p>
  
  <p>OK feel a little silly after figuring out that rds starts up on a private 172 subnet. I was able to connect from my ec2 instance. </p>
  
  <p>Question now is there a way to put that on a public address that I can connect to? I would like to configure it with a security group that limits the source ip but then be able to connect to it with psql from my desktop.</p>
  
  <p><strong>Update 2</strong></p>
  
  <p>I don't remember all the details when I originally posted this question but it is no longer an issue. We now have a management vpc that we connect to using a vpn server. The management vpc network is trusted by the prod and devel security groups for the rds instances. We have no problem communicating with them without adding any public ips.</p>