Tag Archives: AWS

Aurora read replica option is not available for RDS PostgreSQL

Posted on by Leave a comment

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 VersionAurora Read Replica Version Supported
  
9.6.19.6.8, 9.6.9
9.6.29.6.8, 9.6.9
9.6.39.6.8, 9.6.9
9.6.59.6.8, 9.6.9
9.6.69.6.8, 9.6.9
9.6.89.6.8, 9.6.9
9.6.99.6.9
9.6.109.6.11, 9.6.12
9.6.119.6.11
9.6.129.6.12
9.6.14No Aurora Read Replica
9.6.15No Aurora Read Replica
9.6.16No Aurora Read Replica
9.6.17No Aurora Read Replica
9.6.18No Aurora Read Replica
  
10.110.4, 10.5, 10.6, 10.7, 10.12
10.310.4, 10.5, 10.6, 10.7, 10.12
10.410.4, 10.5, 10.6, 10.7, 10.12
10.510.5, 10.6, 10.7, 10.12
10.610.6, 10.7, 10.12
10.710.7, 10.12
10.910.11, 10.12
10.1O10.11, 10.12
10.1110.11, 10.12
10.1210.12
10.13No Aurora Read Replica
  
11.111.4, 11.7
11.211.4, 11.7
11.411.4, 11.7
11.511.6, 11.7
11.611.6, 11.7
11.711.7
11.8No Aurora Read Replica
  
12.2No Aurora Read Replica
12.3No Aurora Read Replica

script to download database log files from aws rds to local linux box

Posted on by Leave a comment
To download all the PostgreSQL error logs from RDS instance to Linux machine use the below script.

for i in `aws rds describe-db-log-files –db-instance-identifier $instancename –query ‘DescribeDBLogFiles[*].[LogFileName]’ –output text`
do
file_name=`echo $i | cut -d’/’ -f2`
aws rds download-db-log-file-portion –db-instance-identifier  –log-file-name $i –starting-token 0 –output text > $file_name
done