Scribd
Upload
2 views5 pages

Aws Rds Guide

This document provides a step-by-step guide for creating a PostgreSQL database in AWS RDS. It includes instructions on logging into the AWS Management Console, selecting database options, and configuring settings such as instance identifier and master username. The guide emphasizes using specific names for consistency and ensuring public accessibility for connections from external sources.

Uploaded by

manlara
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views5 pages

Aws Rds Guide

This document provides a step-by-step guide for creating a PostgreSQL database in AWS RDS. It includes instructions on logging into the AWS Management Console, selecting database options, and configuring settings such as instance identifier and master username. The guide emphasizes using specific names for consistency and ensuring public accessibility for connections from external sources.

Uploaded by

manlara
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

AWS_RDS_guide.

md 5/6/2019

Creating a PostgreSQL Database in AWS RDS


Log in to the AWS Management Console and navigate to the RDS section under All services find
Database, then select RDS.

Click Create database from the Create database section to the right. This button will take you to the
Engine options page, which brings up a menu of different relational databases.

1/5
AWS_RDS_guide.md 5/6/2019

Note: AWS may have a different screen than the one pictured below. If this is the first time using the
service, the orange Create database will still be on the right.

Note: There may be an option to create a database with Amazon Aurora, which is a paid database. We
will not be using this in today's lesson.

IMPORTANT: Check the box next to Only enable options eligible for RDS Free Usage Tier at the
bottom of the menu.

Select PostgreSQL and click Next.

2/5
AWS_RDS_guide.md 5/6/2019

Keep the default settings for the instance specifications.

Fill out the fields under Settings. Use myPostgresDB as the database instance identifier and root as the
master username.

While you can name the database instance identifier and master username anything you like, we
recommend sticking to these settings during today's lesson for consistency.

Enter a password and be sure to record it somewhere. You will need your password to connect to your
database from pgAdmin. Your other RDS settings will be accessible in the future, but the password will
not. Click Next to continue.

3/5
AWS_RDS_guide.md 5/6/2019

Under Network & Security select Yes under the Public accessibility option.

This allows connections from outside sources like pgAdmin. A password will still be required.

Under Database Options, make the database name my_data_class_db.

4/5
AWS_RDS_guide.md 5/6/2019

Again, you can name the database anything you like, but during today's lesson, use this name for
the sake of consistency. Feel free to use any name when creating RDS databases in the future.
Keep the default settings in all other fields.

Click Create Database followed by View DB Instance details to navigate to the instance console page.
AWS will take up to 15 minutes to create a database (but probably less time than that).

You have now created a PostgreSQL database on AWS's RDS cloud platform!

5/5

You might also like