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 AWS Data Migration Service.