How to create an AWS RDS instance
Welcome to CloudAffaire and this is Debjeet.
In the last AWS blog series, we have discussed 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’.
Step 2: Click on ‘Create Database’.
Step 3: Select ‘PostgreSQL’ as the database engine and click ‘Next’.
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’.
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’.
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.
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’
Our PostgreSQL database instance created successfully.
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’.
Provide final backup details and click ‘Delete’.
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