Skip to main content

AWS-RDS Postgres Setup

Setting Up a Free Tier Amazon RDS MySQL Database Instance​

Amazon RDS is a managed relational database service that makes it easy to set up, operate, and scale a relational database in the cloud. With Amazon RDS, you can set up, operate, and scale a Postgres database in the cloud.

As a reminder, all of this is Free Tier eligible, but Amazon may change the steps/pricing at thier discretion. SeeQR is also compatible with paid AWS databases, if you wish to use them for your development.

Prerequisites​

Before you can set up an Amazon RDS Postgres database instance, you must have the following:

  • An AWS account
  • Basic knowledge of using the AWS Management Console

Steps​

Follow these steps to set up a free tier Amazon RDS Postgres database instance:

  1. Open the Amazon RDS console.

  2. In the upper-right corner of the console, choose the AWS Region where you want to create your DB instance.

    AWS Cloud resources are housed in highly available data center facilities in different areas of the world. Each Region contains multiple distinct locations called Availability Zones. You have the ability to choose which Region to host your Amazon RDS activity in.

  3. In the left navigation pane, choose Databases.

  4. Choose Create database.

  5. For Engine options, choose Postgres.

  6. For Templates, choose Free tier.

  7. For Settings, configure the following:

    • DB instance identifier: Type a name for your DB instance that is unique for your account in the Region you selected.
    • Master username: Type a name for the master user.
    • Master password: Type a strong password for the master user.
    • Confirm password: Retype the master password.

    Be sure to store your credentials in a safe place, you will need them later!

    • DB instance class: Select db.t2.micro.
    • Storage type: Select General Purpose (SSD).
    • Allocated storage: Type 20 to allocate 20 GiB of storage.
    • Public accessibility: Select Yes.

  8. Leave the other options with their default values.

  9. Choose Create database.

    It can take a few minutes for your database instance to be created and ready to use.

  10. After your DB instance is created, select the DB instance in the list on the Amazon RDS console.

  11. In the Connectivity & security tab, find the Endpoint field. This is the endpoint that you use to connect to your database.

The endpoint is in the form database-identifier.region.amazonaws.com.

You now have a free tier Amazon RDS Postgres database instance that you can use with SeeQR.