How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

How to create an AWS RDS instance

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In the last AWS blog series, we have discussed CloudFormation.

https://cloudaffaire.com/category/aws/cloudformation/

In this blog series, we are going to start with AWS RDS service and in this blog post, we will create our 1st RDS instance using PostgreSQL.

How to create an AWS RDS instance:

Step 1: Login to AWS console and navigate to ‘RDS’.

How to create an AWS RDS instance

Step 2: Click on ‘Create Database’.

How To Create An AWS RDS Instance

Step 3: Select ‘PostgreSQL’ as the database engine and click ‘Next’.

How To Create An AWS RDS Instance

Note: AWS RDS provides different database engine options like MS SQL Server, Oracle, MySQL, etc. In this series, we will explore different RDS concepts using PostgreSQL database engine. Check “Only enable options eligible for RDS Free Tier” to create the RDS instance for free.

Step 4: Provide RDS instance details and click ‘Next’.

How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

Note: Remember the database instance name, username, and password, we will need this information when we make a connection to the RDS instance.

Step 6: Provide additional configuration details for your database instance and click ‘Create database’.

How To Create An AWS RDS Instance

Note: We will connect to the RDS instance through an EC2 instance hosted in the same VPC. If you want to connect to the RDS from a system not hosted in your VPC (for example from your home’s computer) you need to make the instance publicly accessible. Make sure port 5432 (default port for PostgreSQL) is open in your security group.

How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

How To Create An AWS RDS Instance

Note: We have disabled most of the RDS configurations while creating the RDS instance.

You will get a success message, click ‘View DB instance details’

How To Create An AWS RDS Instance

Our PostgreSQL database instance created successfully.

How To Create An AWS RDS Instance

Below is the RDS details that we have just created

  • Instance name: myinstance
  • User name: myuser
  • User password: xxxxxxxx
  • Database name: mydb
  • Endpoint: mydbinstance.xxxxxxxxxxxx.ap-south-1.rds.amazonaws.com
  • Port number: 5432

Step 7: Cleanup (Do not delete, if you want to continue with the series).

Select the database instance and from ‘Actions’ click ‘Delete’.

How To Create An AWS RDS Instance

Provide final backup details and click ‘Delete’.

How To Create An AWS RDS Instance

Hope you have enjoyed this article, In the next blog post, we will discuss how to connect to the PostgreSQL database instance form an EC2 instance.

To get more details on AWS RDS, please refer below AWS documentation

https://docs.aws.amazon.com/rds/index.html

 

Leave a Reply

Close Menu