Maintained with ☕️ by
IcePanel logo

Amazon Aurora supports PostgreSQL 12



Amazon Aurora with PostgreSQL compatibility now supports major version 12\. [PostgreSQL 12]( 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]( 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]( You can also use the in-place upgrade functionality to minimize downtime during an upgrade. Please review [the Aurora documentation]( 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]( page. Check out this post on the [AWS Database Blog]( to learn more about the new PostgreSQL 12 functionality.