Aurora PostgresSQL major version upgrade

Question

I received a notice that "Aurora PostgresSQL major version 10.x will be de-supported and will be upgraded automatically on 01/31/2023.  You can initiate an upgrade of your database instance either immediately or during your next maintenance window to a newer major version of Amazon Aurora PostgreSQL using the AWS Management Console or the AWS Command Line Interface (CLI)."

I like to test upgrade by having some dev database to upgrade to v11 during next maintenance window.  Is there a way to trigger that?   On the console under pending maintenance I only see the minor upgrade pending.  Or should I upgrade manually?

Thanks.

Answer

Sure, you can restore a backup of your cluster and then just request an upgrade on the new cluster from the console. You click modify, and then select the major version you want and click apply.

Aurora PostgresSQL major version upgrade

Conteúdo relevante