RDS PostgreSQL now supports point-and-click upgrade from PostgreSQL 9.3 to 9.4

Posted on: Nov 19, 2015

Starting today, you can upgrade your RDS PostgreSQL database instance from major version 9.3 to 9.4 with just a few clicks on the AWS Management Console. PostgreSQL 9.4 offers several performance and feature benefits over PostgreSQL 9.3 for many customers. This includes support for the JSONB datatype, which allows you to manage schemas more flexibly. We encourage you to read about what's new in PostgreSQL 9.4 and test your application for compatibility before you upgrade your databases to version 9.4. To upgrade, simply select the "Modify" option on the AWS Management Console corresponding to the DB instance you want to upgrade, choose the version of PostgreSQL 9.4 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, your database instance will have an availability impact for a few minutes as the upgrade completes, and your database instance is rebooted. Please review the AWS User Guide to learn more.