Amazon Web Services or AWS is the cloud service providing platform containing over 200 IT-based services over the internet. Relational Database Service or RDS is the AWS service that is used to create databases using different engines on the cloud. The user is allowed to create a database using the PostgreSQL engine in the AWS RDS.
This guide will explain the creation of an AWS RDS PostgreSQL database.
How to Create an AWS RDS PostgreSQL Database?
To create a PostgreSQL database in AWS RDS, it is required to sign in to the AWS dashboard and click on the “RDS” button:
Clicking on the RDS button will direct the user to the RDS dashboard; click on the “Create database” button from there:
Click on the “Standard create” button to choose a database creation method:
To create a “PostgreSQL” database, select its engine from the available “Engine options”:
Choose the latest version of the PostgreSQL engine and then select the “Free Tier” option from the Templates section:
Type the name of the database instance and the Master username:
Set the password for the master user and confirm it by typing it again:
Configure the storage section by providing its type, Allocated Storage, and threshold:
Choose the “Compute resource” and “Network type” from the connectivity section:
Select the subnet of the database and select “Yes” to allow public access:
Select the existing VPC that is already available on the AWS account:
Select the “Password authentication” option from the “Database authentication” section:
Configure the “Monitoring” section by selecting the retention period and AWS KMS key:
Review the settings and click on the “Create database” button:
The PostgreSQL database has been created successfully:
That’s all about how to create a PostgreSQL database in AWS RDS.
Conclusion
To create a PostgreSQL database in AWS RDS, visit the RDS dashboard from the AWS account after signing in to it. On the RDS dashboard, create an RDS database using the PostgreSQL engine and its latest version. Configure its settings by typing the name and password for the database to be used for the connection. This guide has explained the creation process of a PostgreSQL database in AWS RDS.
