Maintained with ☕️ by
IcePanel logo

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.