Major Version Upgrade Aurora PostgreSQL 11

Question

Hi,  
Hope you are well.  
I have a question on "Major version upgrade" activity in Aurora PostgreSQL. I know why AWS does not manage the 'PostgreSQL _Major_ Version Upgrade' because it does not have backward compatibility and has application dependencies.  
  
**Option(s):**  
  
\[1]in-line upgrade (pg_upgrade) is not managed by AWS in Aurora PostgreSQL ( unlike minor version upgrade).  
  
\[2]export / import (pg_dump,restore) : Create another Aurora Cluster with Higher version (target) and export from lower version of Aurora PostgreSQL (Source, let's say ver10) and import to Higher version (let's say Ver 11).For BIG sized database it takes long time and downtime will be high,  
  
\[3]Replication by DMS : For BIG sized database, it is always an overhead of almost every time whenever there is a newer major version (10>11>12).   
  
**What's the more advisable way of doing that keeping in mind the database size is 30TB of data?**  
**Is there any plan for AWS to manage Major Version Upgrade at present or future like auto minor version upgrade ?**    
  
Thanks,

Answer

In general, we target supporting in-place major version upgrade (MVU) between PostgreSQL major versions for both Aurora PostgreSQL and RDS for PostgreSQL. We are targeting support for MVU to all supported major versions of PostgreSQL in Aurora PostgreSQL, and when we add support for a new major version, we will add support for MVU to that version either concurrently or as soon as possible afterwards.

Answer

Thanks very much

Answer

Hi Kevin ,  
Thanks for the response. Will AWS also support in-place major version upgrade for Aurora PostgreSQL 11 to 12 ( Once Version 12 is available in Aurora). ? Or in future does it support  in-place major version upgrade for Aurora PostgreSQL from any major version to other major version?   
  
This will make our strategy to move to Aurora PostgreSQL more clear which lead to better decision to move to Aurora PostgreSQL.  
Thanks,  
  
Edited by: DipankarAws100Per on Jul 7, 2020 3:59 PM

Answer

We currently support in-place major version upgrade for Aurora PostgreSQL 9.6 to 10 as part of the Aurora PostgreSQL console and API; we are working to add support for 10 to 11 later this year.  
  
-Kevin J (PM for Aurora PostgreSQL)

Major Version Upgrade Aurora PostgreSQL 11

Relevanter Inhalt