Change security group on AWS RDS Database Instance

Question

I've created a Postgresql database instance via AWS RDS. I am now trying to connect to it from my django app, so I created a new security group and changed the imbound rules.

However how do I make this new rule active? I go onto my database instance and under "Security Groups" it only says:

default (sg-9a15a9f0)
( active )

and doesn't show the new security group I created. In the Security Group UI, I can't find a button to make the new security group active.

Any idea?

Answer 1

Your Amazon RDS database is currently using the "default" security group. Therefore, you have two choices:

• Modify the default security group, or
• Create a new security group (as your have done), then go to the RDS console, click on your database, then choose Instance actions -> Modify and modify the security groups that are associated with the DB instance (add the new security group, remove the default security group)

Security groups are set up within the EC2 service, so to create a new security group, go to the EC2 service, then click Security Groups on the left, under Network & Security.

Answer 2

To modify the default security group simply follow the next steps

1. Go to Amazon RDS console

2. Click on the instance

3. Click on the security group

4. Add an inbound rule

Answer 3

Its better to not add open inbound rules to the default security group attached to the DB Instance. Create a new Security group and then Modify your DB Instance where you can select the newly created security group. Note that you can attach more than one Security group to the DB Instance.

Answer 4

Best option is to modify the security group as this group is already attached to the Postgresql.

If you don't want to use the default one at all the while creation of postgresql choose the correct SG to avoid this kinds of ambiguity.