Amazon Redshift Federated Query with RDS PostgreSQL

   Go back to the Task List
  « 1: Pre-requisite    3. Launch RDS Instance »

2: Create Security Group

Let’s create a Security Group which is used by the RDS instance.

  1. Login to AWS Management Console and change the region to Ireland.

  2. Goto VPC Management Console. Click on the Security Groups menu in the left and then click on the Create security group button.

    Security Group

  3. On the next screen, type in dojo-postresql-sg for the security group name and the description fields. Select the default VPC for the VPC field. Create inbound rule for PostgreSQL type from the Source = 0.0.0.0/0. Keep rest of the configuration to the default. Click on the Create security group button.

    Security Group

  4. The security group is created in no time. You launch PostgreSQL RDS instance in the next step.