Migrating an On-site PostgreSQL Database to Amazon Aurora

1.25 hours
  • 3 Learning Objectives

About this Hands-on Lab

In this lab, students are asked to migrate an on-site PostgreSQL instance to Amazon Aurora using the Database Migration Service (DMS). After completing this lab, students will have hands-on experience migrating data using DMS.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create Replication Instance

Create a new DMS replication instance of instance class db.t3.medium. Be sure to select the Lab VPC and create a Single AZ instance. The instance will not need to be publicly accessible.

Create Endpoints

Create the target and source endpoints.

  • Source endpoint will connect as the dms_user to the qa database on the PostgreSQL instance running on the lab bastion host.
  • Target endpoint will connect as the postgres user to the postgres database on the Amazon Aurora cluster.
Create Task

Create a new task and select the source and target endpoints. This migration will copy any existing data from all tables and schemas on the source database to the target and replicate ongoing changes.

Additional Resources

Help Steady Shelly the DBA show Hurry-Up Hank the manager how to migrate their database.

To accomplish this, you will need to complete the following tasks:

  • Create the replication instance.
  • Create the connection endpoints.
  • Create and run the DMS task.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?