Viswamitra's blog

We tried to migrate our existing RDS PostgreSQL instance of 9.5 version to 11.8 version. Below are the steps we followed after checking the documentation. The maximum Aurora PostgreSQL version supported is 11.8.

1. upgrade existing RDS PostgreSQL to 11.8 version
2. create read replica for existing RDS PostgreSQL instance
3. Once both instances are in sync, promote read replica

When we were performing this on dev machine we found that RDS do not support read replica creation for 11.8. After discussing with AWS team they confirmed that RDS do not support Aurora read replica for all PostgreSQL versions. Below are details which can help others who want to migrate to Aurora.

RDS PostgreSQL Version	Aurora Read Replica Version Supported
9.6.1	9.6.8, 9.6.9
9.6.2	9.6.8, 9.6.9
9.6.3	9.6.8, 9.6.9
9.6.5	9.6.8, 9.6.9
9.6.6	9.6.8, 9.6.9
9.6.8	9.6.8, 9.6.9
9.6.9	9.6.9
9.6.10	9.6.11, 9.6.12
9.6.11	9.6.11
9.6.12	9.6.12
9.6.14	No Aurora Read Replica
9.6.15	No Aurora Read Replica
9.6.16	No Aurora Read Replica
9.6.17	No Aurora Read Replica
9.6.18	No Aurora Read Replica
10.1	10.4, 10.5, 10.6, 10.7, 10.12
10.3	10.4, 10.5, 10.6, 10.7, 10.12
10.4	10.4, 10.5, 10.6, 10.7, 10.12
10.5	10.5, 10.6, 10.7, 10.12
10.6	10.6, 10.7, 10.12
10.7	10.7, 10.12
10.9	10.11, 10.12
10.1O	10.11, 10.12
10.11	10.11, 10.12
10.12	10.12
10.13	No Aurora Read Replica
11.1	11.4, 11.7
11.2	11.4, 11.7
11.4	11.4, 11.7
11.5	11.6, 11.7
11.6	11.6, 11.7
11.7	11.7
11.8	No Aurora Read Replica
12.2	No Aurora Read Replica
12.3	No Aurora Read Replica