Creating a PostgreSQL database in AWS

In this section, we'll be creating a PostgreSQL database in AWS, downloading a utility called psql to connect to it, and finally, loading some sample data into it. Let's get started.

PostgreSQL is a popular open source database. It's actually what is running behind the scenes in our Metabase instance as the application database. In that case, it was created automatically by the Elastic Beanstalk configuration. Here, we will create one from scratch, using Relational Database Service (RDS) in AWS. Let's get started:

Important Note

You get 750 hours of RDS a month on the Free Tier. Since we're already using one of these to power our Elastic Beanstalk app, you will now be charged if you leave both running all month long. As of the time of writing, a db.t2.micro instance costs around USD 0.03 per hour.

1. Log in to AWS as the metabase-admin IAM user and find the RDS service in the AWS Management Console.
2. Click...