Posted On: Feb 28, 2023

Amazon Relational Database Service (Amazon RDS) for PostgreSQL now supports the latest major version PostgreSQL 15. 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. The PostgreSQL 15 release also adds support for new extension pg_walinspect and 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.

Amazon RDS for PostgreSQL supports over 80 extensions and loadable modules including PostGIS 3.3.2 for geospatial data, plv8 3.1.4, pgrouting 3.4.1 , and pg_hint_plan 1.5.0. You can upgrade your database using several options including upgrade in-place, restore from a snapshot, replicate with the pglogical extension, or use Amazon Data Migration Service. You can find more technical details in the blog.

Amazon RDS for PostgreSQL helps make it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Amazon RDS for PostgreSQL is available in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console.