RDS PostgreSQL: how to move to the version15?

Question

I have now RDS PostgreSQL v9.*, it works a few years. It started with v9.* and still use it.
Now I'd like to use some new features (for example bloom filters etc) so move to v15.
1. How can I switch to v15 (move database etc)?
2. Can it be done automatically or manually? 
3. Does it cost for me additionally?

Answer

Hi Oleg,

Further to Riku's comments, depending on which version of Postgres you're using you'll likely have to upgrade to 14.1 first before going to 15.2. See this section of the guide for further details - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion

Riku is right there are no fees for upgrading, and it has to be manually initiated from either the command line or console.

I hope that helps Oleg :)

Thanks

Answer

RDS PostgreSQL can be upgraded as described in the following document.  
You said you are using version 9 so once you upgrade to 14.1 you will need to upgrade to 15.2.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html

The upgrade itself can be done manually, and we are aware of no special fees.  
Since this will be a fairly large upgrade, we recommend that you take a snapshot and make sure it works well with your application before executing it.

RDS PostgreSQL: how to move to the version15?

Relevant content