RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
According to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Import.Console it's possible to migrate PostgreSQL RDS (12.7) to Aurora by adding Aurora Read Replica. But I have no such option for my PostgreSQL RDS. Is it has some problems in this feature?
I tried other options "Migrating an RDS for PostgreSQL DB instance using a snapshot", but it also inacitvated button in my dashboard.
Is it possible that the feature was announced but isn't available yet?
This is an known issue identified by our internal team and investigation is on going.
I personally have tested that option to create aurora read replica works for below versions through console.
RDS PostgreSQL 12.5 RDS PostgreSQL 9.6.21
For RDS PostgreSQL 12.7, no option presents from the console.
Workaround is to use CLI command:
Use below to create a cluster:
aws rds create-db-cluster --db-cluster-identifier Aurora-cluster --engine aurora-postgresql --db-subnet-group-name <subnet-group-name-here> --replication-source-identifier <source-RDS-instance-arn> --region us-east-1 --engine-version 12.7
Use below to add instances to the cluster via the CLI command:
aws rds create-db-instance --db-instance-identifier <instance-identifier> --db-instance-class <instance-class> --engine aurora-postgresql --db-cluster-identifier <db-cluster-identifier> --region us-east-1
Hope CLI command can help you workaround the issue.
I'm experiencing the same problem from RDS console. and would prefer not to have to resort to CLI in future. is there an ETA on this fix?
I'm experiencing the same problem on 13.4 - I've managed to migrate my Test and Staging databases but not the production one. Any idea when this might be fixed?
Looks like AWS does not care about this issue and no one is going to fix it. What a shame!
Thanks Kevin! It's really helpful!!!
I experience same issue with RDS Postgres 11.13
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.Accepted Answerasked 4 months ago
Migrate snapshot option disabledasked a year ago
How to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?asked a day ago
Best practices for migrating MySQL RDS to Aurora ServerlessAccepted Answerasked 3 years ago
Not able to see " Creare Aurora readreplica" button from RDS Postrgresasked 9 days ago
Migration from Aurora PostgreSQL back to regular RDSAccepted Answerasked 3 years ago
No Options to migrate from RDS Postgres to Auroraasked a month ago
Migrating RDS PostgreSQL to Aurora PostgreSQL in a different accountAccepted AnswerEXPERTasked a year ago
RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtimeasked 4 months ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago