RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime
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.
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/
This could be a good use case for DMS with continuous replication:
- use DMS for ongoing replication
- move read endpoints to Aurora
- move write endpoints to Aurora
https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.mysql2rds.replication.html
Relevant questions
RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime
asked 4 months agoMigrate snapshot option disabled
asked a year agoChanges to connection handling with Aurora Postgres?
Accepted Answerasked 3 years agoaurora postgres major upgrade - pg_dumpall
asked 3 years agoXA Global Transaction Support for Aurora Postgres
asked 3 months agoPostGIS and Aurora compatibility: experience feedback
Accepted AnswerMigration from Aurora PostgreSQL back to regular RDS
Accepted Answerasked 3 years agoUpgrade RDS Postgres engine from 9.6.11 to 10.6 - Migrate to Aurora
Accepted Answerasked 3 years agoMigrating from RDS MariaDB 10.2 to Aurora MySQL 5.6
Accepted Answerasked 3 years agoUse RDS Postgres Replicas as a cluster
Accepted Answerasked 4 months ago