By using AWS re:Post, you agree to the Terms of Use
/RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime/

RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime

1

Good evening ... as the subject states, we are currently running an RDS version of postgres 12.7 and wish to migrate over to Aurora. I would assume the easiest would be to create an aurora read replica, test all functions (including postGIS), and once confirmed things work, promote that and should be good however the create aurora read replica is not showing on the console. I saw a few threads about that being a big but that was months ago.

This database gets thousands of updates every minute, so really trying to keep the downtime to nothing or as little as possible, so any guidance or help is appreciated.

2 Answers
1

I've seen the same issue too - I found this discussion which suggests it's a console bug only and the workaround is to use CLI. https://www.reddit.com/r/aws/comments/qcbgfr/option_to_create_aurora_read_replica_of_rds/

answered 4 months ago
1

This could be a good use case for DMS with continuous replication:

  1. use DMS for ongoing replication
  2. move read endpoints to Aurora
  3. move write endpoints to Aurora

https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.mysql2rds.replication.html

answered 4 months 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