Creating and Connecting to Amazon RDS

In this chapter, we will move our PostgreSQL database from a local server to a live server provided by Amazon.

The first thing you need is an AWS account. If you don’t have one already, go to https://aws.amazon.com and create one. A credit card is required but you will not be charged to use the free tier services that we’ll discuss in this lesson.

Executing commands using AWS CLI

Use the terminal below to execute the AWS CLI commands for creating and managing the Amazon RDS instance. To use the AWS CLI, you need to configure the AWS credentials.

You must already have your AWS Access Key ID and AWS Secret Access Key stored somewhere. If you don’t have them or want to create new ones, please follow these steps:

1. Log in to your AWS account
2. Click on the Services dropdown at the top left corner
3. Click on IAM under Security, Identity, & Compliance
4. Click on Users in the left sidebar
5. Select (or create) the user you want to get the keys for
6. Open the Security credentials tab
7. Choose Create access key

Every time you connect to the following terminal, you need to configure your AWS credentials. We have automated this step for you. Whenever you connect to the terminal, your AWS credentials will already be configured. Just provide your AWS Access Key ID and ...