Posted On: Aug 13, 2019

Amazon RDS now supports PostgreSQL major version 11 in Amazon Web Services China (Beijing) region, operated by Sinnet and Amazon Web Services 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.

With PostgreSQL 11, pgaudit has been updated to 1.3.0, pg_hint_plan 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.

Following the announcement of updates to the PostgreSQL database, we have also updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11,2, 10.7, 9.6.12, 9.5.16, and 9.4.21. This release contains bug fixes and improvements done by the PostgreSQL community.

With this PostgreSQL 11.2 release, 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.

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.