Posted On: May 12, 2023

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL major version 15(15.2). New features in PostgreSQL 15 include the SQL standard "MERGE" command for conditional SQL queries, performance improvements for both in-memory and disk-based sorting, and support for two-phase commit and row/column filtering for logical replication. PostgreSQL 15 release also adds support for server-side compression with Gzip, LZ4, or Zstandard (zstd) using pg_basebackup. Please refer to the PostgreSQL community announcement for more details about the release. This release includes new features for Babelfish for Aurora PostgreSQL version 3.0. Please refer to Amazon Aurora PostgreSQL updates for more information.

To use the new version, create a new Aurora PostgreSQL-compatible database instance with just a few clicks in the Amazon RDS Management Console. You can also upgrade existing database instances. Please review the Aurora documentation to learn more about upgrading. PostgreSQL 15 is available in Amazon Web Services China (Beijing) Region, operated by Sinnet and the Amazon Web Services China (Ningxia) Region, operated by NWCD. Refer to the Aurora version policy to help you to decide how often to upgrade and how to plan your upgrade process. 

Amazon Aurora is designed for unparalleled high performance and availability at global scale with full MySQL and PostgreSQL compatibility. It provides built-in security, continuous backups, serverless compute, up to 15 read replicas, automated multi-Region replication, and integrations with other Amazon Web Services services. To get started with Amazon Aurora, take a look at our getting started page.