Maintained with ☕️ by
IcePanel logo

Amazon RDS Now Supports PostgreSQL 12

Share

Services

Amazon RDS for PostgreSQL now supports major version 12\. [PostgreSQL 12](https://www.postgresql.org/about/news/1976/) includes better management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations that support case-insensitive and accent-insensitive comparisons for ICU provided collations, most common-value statistics for improved query plans, creation of generated columns that computes values with an expression, and many additional features. This release updates extensions including [PostGIS](https://postgis.net/) to version 3.0, [PGAudit](https://www.pgaudit.org/) to version 1.4, [wal2json](https://github.com/eulerto/wal2json/blob/master/README.md) to version 2.1, [PLV8](https://plv8.github.io/) to version 2.3.14, [Orafce](https://github.com/orafce/orafce/blob/master/README.asciidoc) to version 3.8, [pg\_repack](https://reorg.github.io/pg%5Frepack/) to version 1.4.5, [pg\_hint\_plan](https://github.com/ossc-db/pg%5Fhint%5Fplan) to version 1.3.5.22a77c, and [pglogical](https://github.com/2ndQuadrant/pglogical) to version 2.3.0. To use the new version, you can create a new [Amazon RDS for PostgreSQL](/rds/postgresql/) database instance with just a few clicks in the [AWS Management Console](https://console.aws.amazon.com/console/home). Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. See [Amazon RDS for PostgreSQL Pricing for pricing](/rds/postgresql/pricing/) details and regional availability. Learn more about the new functionality of PostgreSQL 12 in the [AWS Database Blog](https://aws.amazon.com/blogs/database/postgresql-12-a-deep-dive-into-some-new-functionality).