Posted On: Aug 7, 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 Amazon Web Services Management Console.
PostgreSQL 11 includes major improvements to partitioning, parallelism, and many other useful performance improvements like adding columns with a non-null column default faster. This version includes SQL-stored procedures that allow embedded transactions within a procedure.
To upgrade, select the "Modify" option on the Amazon Web Services 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, your 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.