Upgrading from PostgreSQL 9.4.21 to 9.6.x unavailable in Console

Question

I'm trying to upgrade my PostgreSQL 9.4.21 to 9.6.x, but there is no available upgrade showing in the console. I can only upgrade to 9.5, 10.7, or 11.2  
  
Is this because I need to upgrade to 9.5 first, before upgrading to 9.6?  
  
Since 10.7 and 11.2 are showing as available, can I upgrade directly to those versions without an intermediary step?  
  
TIA.

Answer

Hi bryanus,  
  
Yes, if you want to specifically upgrade to PostgreSQL 9.6  from 9.4.x, you will have to first do a major version upgrade to 9.5 and then to 9.6. However if you want to go to the latest Major versions you can do it directly based on the extensions that you are using in 9.4.x. Please look at the table on https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion   
to figure if your instance will qualify to direct upgrade to PostgreSQL 11 or 10.  
  
Hope this helps.  
  
Regards,  
Jignesh

Answer

Ahh, thank you Jignesh!

Upgrading from PostgreSQL 9.4.21 to 9.6.x unavailable in Console

Contenuto pertinente