By using AWS re:Post, you agree to the Terms of Use

RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.

1

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?

3 Answers
2
Accepted Answer

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.

SUPPORT ENGINEER
answered 9 months 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?

  • 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!

0

Thanks Kevin! It's really helpful!!!

answered 8 months ago
0

I experience same issue with RDS Postgres 11.13

answered 5 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