Amazon Aurora with PostgreSQL compatibility supports in-place upgrade from PostgreSQL 9.6 to 10

Posted on: Mar 5, 2020

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

PostgreSQL 10 includes various features including native table partitioning, support for improved parallelism in query execution, ICU collation support, column group statistics, enhanced postgres_fdw extension, and many more. Additionally, this release includes updated versions of the PLV8, ip4r, and pg_repack extensions.

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 10 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 may be applied immediately (if you select the "Apply Immediately" option), or during your next maintenance window (by default). Please 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.