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

Question

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?

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  --replication-source-identifier  --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  --db-instance-class  --engine aurora-postgresql --db-cluster-identifier  --region us-east-1

Hope CLI command can help you workaround the issue.

Answer

I experience same issue with RDS Postgres 11.13

Answer

Thanks Kevin!
It's really helpful!!!

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

Workaround is to use CLI command:

Relevant questions

Aurora read replica for RDS Postgres and long-term use

Aurora PostgreSQL Replica Pricing