"Create Aurora Read Replica" option not available to migrate from RDS Postgres 11.12 to Aurora 11.12.
According to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica.Create I should be able to create a Aurora Postgres Read Replica from RDS Postgres 11.12 instance. But the option does not exist in the dropdown menu when the DB primary is selected (or read replicas). The region is us-east-1, N. Virginia. Thanks for the help!
Looks like an issue with the console. Can you please try using AWS CLI for that:
To create Aurora replica cluster use the following CLI command "create-db-cluster" with "--replication-source-identifier" option first and then add instances to it using "create-db-instance".
Here is an example:
$ aws rds create-db-cluster --db-cluster-identifier "name of new replica cluster" --engine aurora-postgresql --db-subnet-group-name "subnet-group-name-here" --vpc-security-group-ids "security-group-id-here" --replication-source-identifier " postgreSQL RDS source-instance-ARN" --engine-version 11.12 --storage-encrypted --kms-key-id "KMS-key-ARN-here"
Above command is a one liner
If your source RDS instance has storage encryption, you may need to also include the "--storage-encrypted" flag to the above command
The option "--replication-source-identifier" is mandatory to setup replication between the resources
At this point Aurora replica cluster should be created with no instances. To add instances to the cluster you can use "create-db-instance". Below is the example:
$ aws rds create-db-instance --db-cluster-identifier "name of new replica cluster above" --db-instance-identifier "new aurora instance name" --db-instance-class db.t3.medium --engine aurora-postgresql
Creation via CLI worked, thank you! Also has a bug been filed for this, or is there a place I can do that?
Its a known issue, and I am sure it would be fixed soon. You can "accept" the answer, as it might help other users also.
"Create Aurora Read Replica" option not available to migrate from RDS Postgres 11.12 to Aurora 11.12.asked 2 months ago
No Options to migrate from RDS Postgres to Auroraasked 2 months ago
Not able to see " Creare Aurora readreplica" button from RDS Postrgresasked 20 days ago
Best practices for migrating MySQL RDS to Aurora ServerlessAccepted Answerasked 3 years ago
Aurora PostgreSQL Replica Pricingasked 2 years ago
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.Accepted Answerasked 5 months ago
How to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?asked 12 days ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago
Migration from Aurora PostgreSQL back to regular RDSAccepted Answerasked 3 years ago
Upgrade RDS Postgres engine from 9.6.11 to 10.6 - Migrate to AuroraAccepted Answerasked 3 years ago