Posted On: Oct 8, 2019

Following the recent announcement of updates to the PostgreSQL database, we have updated Amazon RDS for PostgreSQL to support new PostgreSQL minor versions. This release contains security fixes, bug fixes and improvements done by the PostgreSQL community.  

With this release, a new Transportable Database feature is added which allows a fast and convenient method of data import and export between databases. By using a new extension pg_transport, large databases can be quickly migrated between RDS PostgreSQL instances. PostgreSQL Transportable Databases is available in RDS for PostgreSQL versions 10.10, 11.5, and newer. For more details about the feature, please refer to the documentation.  

We have also added support for PostGIS 2.5 for all supported major versions. This enables multi major version upgrades to be performed with PostGIS extension, like upgrading from 9.4.24 directly to 11.5 with PostGIS. 

The precheck process used while doing major version upgrades is also improved with this release. Previously, when customers perform major version upgrade, the precheck process scanned for incompatibilities across databases in the instance, but reported only the first issue it encountered. This caused customers to run the major version upgrade process more than once to fix all the incompatible issues and do a successful instance upgrade. The new enhanced precheck process scans for all potential compatibility issues across all databases in the instance and generates detailed, database-level logs. Customers can resolve all the issues based on the logs instead of retrying multiple times. To learn more about the major version upgrade paths and precheck feature, please refer to the documentation

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability.