RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Hi,
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?
Hi,
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 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!
Relevant questions
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Accepted Answerasked 4 months agoMigrate snapshot option disabled
asked a year agoHow to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?
asked a day agoBest practices for migrating MySQL RDS to Aurora Serverless
Accepted Answerasked 3 years agoNot able to see " Creare Aurora readreplica" button from RDS Postrgres
asked 9 days agoMigration from Aurora PostgreSQL back to regular RDS
Accepted Answerasked 3 years agoNo Options to migrate from RDS Postgres to Aurora
asked a month agoMigrating RDS PostgreSQL to Aurora PostgreSQL in a different account
Accepted AnswerRDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime
asked 4 months agoMove RDS postgresql database to Aurora Serverless
Accepted Answerasked 3 years ago
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?