Amazon Aurora supports PostgreSQL 14

Amazon recently announced that Aurora PostgreSQL supports PostgreSQL major version 14. The new version adds performance improvements and new features, including support for SCRAM password encryption.

PostgreSQL 14 includes improvements for parallel queries, heavily concurrent workloads, partitioned tables, logical replication, and scavenging. Version 14.3 adds new features such as the ability to close idle sessions or cancel long-running queries if a client disconnects. Other advantages of PostgreSQL 14 include multirangeallowing representation of non-contiguous data ranges and stored procedures returning data using OUT settings.

The new version of Aurora adds SCRAM password encryption support, an alternative to the default MD5 algorithm for encrypting passwords. SCRAM has been backported to previous versions of Aurora PostgreSQL (10, 11, 12, 13) and AWS recommends using SCRAM rather than MD5 for any new clusters.

Aurora for PostgreSQL provides continuous backups, up to 15 read replicas, multi-region replication, and the option to run in serverless mode. The general availability of the on-demand autoscale configuration was announced last April and is now compatible with PostgreSQL 14.

Existing clusters can be upgraded to PostgreSQL 14 version. Further minor version upgrades can be achieved without downtime, as the cloud provider recently released correction without downtime (ZDP), a feature to preserve client connections across database restarts.

There was initially some worries in the community linked to the choice of version 14.3, but the cloud provider backported some of the more recent 14.4 fixes, including the one for the COMPETITOR bug. To simplify the release process, the Aurora release is moving forward the same way as the major.minor version of the PostgreSQL community versionwith a third digit at the patch location.

Murat Demirbassenior applied scientist at AWS, recently wrote a popular article on the Amazon Aurora decoupled architecture. New release of high-speed, cloud-native relational database includes new features for Babelfish for Aurora PostgreSQL version 2.1, the open source capability to run Microsoft SQL Server applications on PostgreSQL. Version 14.3 is the third major release of the managed service since early 2021: Last year, Aurora introduced support for PostgreSQL 12 and PostgreSQL 13, as reported by InfoQ, showing a significantly shorter release cycle than for MySQL releases.

Amazon Aurora is not the first managed service compatible with PostgreSQL 14: Amazon RDS the support and other vendors have already added support, including PostgreSQL flexible server on Azure and Azure Hyperscale (Citus).

PostgreSQL 14 is available in all Aurora supported regions. There are no price differences between engine versions.

Comments are closed.