pg admin aws rds connectivity issue

If you create a postgresql database in Amazon RDS, are getting a timeout connecting via pgAdmin.

If the troubleshooting steps haven’t helped you.

On the aws rds dashboard, click on the security group for the postgres instance:

_config.yml

Note that there will be a single rule created by default

The default source for the inbound connection is set to the ip address of the machine that was used to create the postgres instance (I am assuming that this should apply to other databases as well).

Edit the rule

_config.yml

Set the source set to Anywhere.

_config.yml

Save the changes and this should resolve the connectivity issue.

Written on May 2, 2018