PostgreSQL in the cloud with Amazon AWS RDS

Configure an AWS RDS PostreSQL database

Click on Services menu then choose RDS in the Databases category or go directly to the RDS console:

rds

 On the next screen, click on Create a database:

rds

Then choose Postgresql as a database engine:

rds

At the next step select Dev/Test as a use case:

rds

In the Instance specifications screen, change the engine version to Postgresql 9.6 and check “Only enable options eligible for RDS Free Usage Tier”, then choose the instance class db.t2.micro:

rds

Then scroll down to get to the Parameters options, and fill the instance DB name, the login and the password fields:

 

rds

 For the final step, choose options “Public accessibility: No” and “Create a new VPC Security Group“:

rds

Scroll down to get to the Database options and fill Database name.Make sure that IAM authentication is deactivated:

rds

Finally, validate the RDS PostgreSQL instance creation:

rds

Go to the RDS Dashboard and select DB Instances to access your database details:

rds

Select your database instance:

rds

Take note of the Termination point URL and the port number, then click on Security groups:

rds

This will get you to the Security Groups management screen. Click on Actions then Modify incoming rules:

rds

We’ll have to modify the existing rule to authorize the AWS RDS database connection from the AWS EC2 instance. Enter the private IP from your AWS EC2 instance in the Source field then confirm:

rds

Now that your AWS EC2 Linux Debian and AWS RDS Postgresql instances are configured, it’s time to move on to Jira installation !

Our Jira experts can help you with your installation and deployment project in AWS Cloud, get in touch with us: we are availalable anywhere in France.

Contactez-nous !

Besoin d’un conseil sur une version logicielle à installer ? D’un coaching ou d’une formation ciblée ? Toute l’équipe de consultants certifiés se tient prête à vous assister ! Notre mot d’ordre : viser la performance en vous garantissant expertise, agilité et réactivité. Nous nous engageons à vous recontacter sous 48h.

Share This