Amazon Aurora supports PostgreSQL 12
Share
Services
Amazon Aurora with PostgreSQL compatibility now supports major version 12\. [PostgreSQL 12](https://www.postgresql.org/about/news/1976/) includes better index management, improved partitioning capabilities, and the ability to execute JSON path queries per SQL/JSON specifications. It also enables 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 compute values with an expression, and many additional features.
This release also updates extensions including Address\_standardizer, Address\_standardizer\_data\_us, Amcheck, Citext, Hll, Hstore, Ip4r, Pg\_repack, Pg\_stat\_statements, Pgaudit, Pglogical, Pgrouting, Plv8, Postgis, Postgis\_tiger\_geocoder, Postgis\_topology. You can view a list of all PostgreSQL extensions supported by Aurora PostgreSQL in the [AWS User Guide](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP%5FPostgreSQL.html#SQLServer.Concepts.General.FeatureSupport).
To use the new version, create a new [Amazon Aurora PostgreSQL](/rds/aurora/) database instance with just a few clicks in the [Amazon RDS Management Console](https://console.aws.amazon.com/console/home). You can also use the in-place upgrade functionality to minimize downtime during an upgrade. Please review [the Aurora documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER%5FUpgradeDBInstance.PostgreSQL.html) to learn more. PostgreSQL 12 is available in [all regions](/about-aws/global-infrastructure/regional-product-services/) supported by Amazon Aurora PostgreSQL.
[Amazon Aurora](/rds/aurora/) combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit [the Amazon Aurora product page](/rds/aurora/). To get started with Amazon Aurora PostgreSQL, take a look at our [getting started](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP%5FGettingStartedAurora.html) page. Check out this post on the [AWS Database Blog](https://aws.amazon.com/blogs/database/postgresql-12-a-deep-dive-into-some-new-functionality) to learn more about the new PostgreSQL 12 functionality.
What else is happening at Amazon Web Services?
Read update
Services
Share
Read update
Services
Share
Amazon Managed Service for Prometheus now supports configuring a minimum firing period for alerts
October 16th, 2024
Services
Share