Search code examples
postgresqlamazon-rds

AWS RDS Postgres connection failure


I am getting started on AWS RDS. I am trying to create a public PostgreSQL instance (free tier) and trying to connect from my local laptop through SQL Workbench. I am following the instructions from this https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/

But, when I try to connect from SQL Workbench, I get "connection attempt failed" error. I have verified the steps, host name, port, dbname to make sure I am not missing any. I am still unable connect from SQL Workbench.

Do I have to take care of any other configurations? Is there a way to debug if the rds db instance is reachable (ping/telnet)? Appreciate any help with this. Thank you!


Solution

  • You should check the following on the Amazon RDS instance:

    • It is set to publicly accessible
    • It is in a public subnet
    • It has a security group configured to permit inbound access from your IP address on port 3306
    • Your local network is not blocking the connection (try it from home, or tethered via your phone)