Posted On: Sep 26, 2019

Amazon RDS now supports PostgreSQL major version 11 in AWS China (Beijing) region, operated by Sinnet and AWS China (Ningxia) region, operated by NWCD. PostgreSQL 11 includes major improvements to partitioning, improvements to 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. 

Following the announcement of updates to the PostgreSQL database, we have updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11.4, 10.9, 9.6.14, 9.5.18 and 9.4.23. This release contains an important security fix and also bug fixes and improvements done by the PostgreSQL community.  

PostgreSQL extension pgaudit has been updated to 1.3.0, to 1.3.2, pglogical to 2.2.1, PLV8 to 2.3.8, PostGIS to 2.5.1, prefix to 1.2.8, and wal2json to hash 9e962ba. A new extension pgTAP, a suite of database functions that make it easy to write unit tests in psql script, is added and supported with PostgreSQL version 11.2 and above. Extension pg hint plan has been updated to 1.3.2 for PostgreSQL versions 11, 10, 9.6 and 9.5. Please refer to the documentation for the various extensions and modules supported in various RDS PostgreSQL versions.

Amazon S3 Import feature is now available for PostgreSQL version 11.1, and 10.7 and later versions. Multi Major Version Upgrades for PostgreSQL feature is now supported which allows you to perform major version upgrades across multiple different major versions. Please refer to the major version upgrade documentation on details around the PostgreSQL versions that are supported as source and target versions and also any limitations associated with the upgrade process. 

To use the new version, you can create a new Amazon RDS for PostgreSQL database instance with just a few clicks in the AWS Management Console. Learn about upgrading your instances in the Amazon RDS for PostgreSQL User Guide. 

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability.