Posted On: Jul 31, 2020

Starting today, you can upgrade your Amazon Aurora with PostgreSQL compatibility database cluster from major version 10 to 11, with just a few clicks in the AWS Management Console.

PostgreSQL 11 includes major improvements to partitioning and parallelism, and many useful performance improvements like adding columns with a non-null column default faster. It supports SQL stored procedures that allow embedded transactions within a procedure.  

To upgrade, select the "Modify" option on the AWS Management Console corresponding to the DB instance you want to upgrade, choose the version of Aurora PostgreSQL 11 you want to upgrade to, and proceed with the wizard. Some of the earlier versions may not be available for upgrade to avoid the possibility of upgrading to a version that was released by the community before your current version. The upgrade will be applied immediately (if you select the "Apply Immediately" option), or during your next maintenance window (by default). Note that in either case, you database will be unavailable for a few minutes as the upgrade completes and your database instances are rebooted. Please review the Aurora documentation to learn more.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora PostgreSQL, take a look at our getting started page.