Posted On: Nov 26, 2019
Amazon RDS now supports PostgreSQL minor versions 11.5 and 10.10 in the AWS GovCloud (US) Regions. Following the announcement of updates to the PostgreSQL database, we have updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11.5 and 10.10. This release contains cumulative fixes including an important security fix, bug fixes, and other 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 for 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, such as 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.