Migrating RDS PostgreSQL to Aurora PostgreSQL in a different account


Hello, I have a customer who needs to move their RDS PostgreSQL database to a different account, and would like to migrate to Aurora while doing so. Just wanted to do a quick sanity check + see if there are simpler options available before I shoot over the following options to the customers.

With downtime

  1. Take snapshot of PostgreSQL database
  2. Share snapshot with new account following these steps (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Import.Console)
  3. Create Aurora cluster from RDS PostgreSQL snapshot

No downtime

  1. Create Aurora cluster in new account
  2. Use DMS to migrate data from RDS PostgreSQL to Aurora cluster in new account (https://aws.amazon.com/blogs/database/set-up-aws-dms-for-cross-account-migration/)

The customer is running RDS PostgreSQL 10.13 at the moment.

asked 3 years ago1200 views
1 Answer
Accepted Answer

Look into Amazon Aurora Fast Cloning as well. It supports Cross-account cloning via Resource Access Manager:

Possible route to take, this will have downtime but will still be minimal, and doesn't require DMS or manually dealing with logical replication:

Having said that, to err on the safe side, I personally would recommend customer to separate this into 2 tasks and not try to group into one operation. One to upgrade to Aurora, and the second to create the fast DB clone cross-account. It will require 2 DNS cutover for the applications or require 2 updates in route 53 if you're using CNAMEs, but will likely make things clearer.

answered 3 years ago
profile picture
reviewed 6 days ago
profile picture
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions