Setup secure connectivity between your RDS and EC2 instances

1. In https://console.aws.amazon.com/rds/home#databases:, select the RDS instance to migrate.
2. Scroll down to Security group rules (1) and select the EC2 Security Group - Inbound group. The Security Groups (1) window opens. Click the Security group ID, then click Edit inbound rules

1. On your intermediary EC2 instance, get your local IP address:

   Bear with me on this one, you need this IP address to enable access to your RDS instance,

2. In Edit inbound rules, click Add rule, then create a PostgreSQL, TCP rule granting access to the local IP address for your EC2 instance (told you 😃). Then click Save rules.