Read our blog for the latest insights on sales and marketing Take Me There

Webinar: Document Merge in wMobile Desktop for GoldMine Register

Amazon Aurora September 2020 Update

Released on September 24th, 2020

Amazon Aurora PostgreSQL Supports pglogical Extension

Starting today, Amazon Aurora PostgreSQL supports the pglogical extension. pglogical is an open source PostgreSQL extension that helps customers replicate data between independent Aurora PostgreSQL databases while maintaining consistent read-write access and a mix of private and common data in each database. Amazon Aurora pglogical uses logical replication to copy data changes between independent Aurora PostgreSQL databases, optionally resolving conflicts based on standard algorithms. Customers can enable pglogical from within their Aurora PostgreSQL instances, and pay only for the additional clusters and cross-region traffic needed, with no upfront costs or software purchases required. Fully integrated, pglogical requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

pglogical is supported for Aurora PostgreSQL 1.6.x or higher (compatible with PostgreSQL 9.6.16 or higher), Aurora PostgreSQL 2.6.x or higher (compatible with PostgreSQL 10.13 or higher), and Aurora PostgreSQL 3.3.x or higher (compatible with PostgreSQL 11.8 or higher). Please review the Aurora documentation to learn more. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide.  

Amazon 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. To get started with Amazon Aurora PostgreSQL, take a look at the getting started page.

Amazon Aurora Increases Maximum Storage Size to 128TB

You can now create Amazon Aurora database clusters with up to 128TB of storage. The new storage limit is available for both the MySQL- and PostgreSQL-compatible editions of Amazon Aurora. Previously, Aurora database instances supported 64TB of storage.

With an increased storage limit of 128TB, you’re less likely to reach the limit when you scale up your application on a single Amazon Aurora database cluster. This means you won’t need to delete data or to split the database across multiple instances. Learn more by visiting the Amazon Aurora Storage and Reliability documentation.  

128TB support is available with Aurora MySQL engine version 1.23, compatible with MySQL 5.6, with engine version 2.09, compatible with MySQL 5.7, and with Aurora PostgreSQL 9.6.17, 10.12 and 11.7.

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. To learn more about Amazon Aurora please see the product page and documentation.

Amazon Aurora PostgreSQL Patches 2.5.4 / 2.6.1 / 3.2.4 / 3.3.1 Now Generally Available

Newer patches 2.5.4 / 2.6.1 / 3.2.4 / 3.3.1 are now available for customers using Amazon Aurora PostgreSQL. For detailed release notes visit the version documentation. You can apply the new patch version in the AWS Management Console, via the AWS CLI, or via the RDS API. For detailed instructions, please see our technical documentation.

Amazon 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. To get started with Amazon Aurora PostgreSQL, take a look at the getting started page.

Announcing Aurora Parallel Query Region expansion and MySQL 5.7 compatibility

Amazon Aurora Parallel Query is now available with MySQL 5.7 compatibility. Parallel Query provides faster analytical queries over your transactional data, speeding up your queries by up to 2 orders of magnitude, while maintaining high throughput for your core transactional workload.

With today’s launch, you can use Parallel Query together with other Aurora MySQL 5.7 features such as Global Database. In addition, availability of the feature for the MySQL 5.7 and MySQL 5.6 databases has been expanded to 20 AWS regions. Read more about Parallel Query on the AWS Blog.

Parallel Query takes advantage of Aurora’s architecture by pushing processing down to the Aurora storage layer, spreading computation across thousands of nodes. By pushing query computation down to the storage layer where possible, Parallel Query limits CPU, memory, and network contention with the core workload.

You can enable Parallel Query on a new or existing Aurora cluster with just a few clicks in the Amazon RDS Management Console or by downloading the latest AWS SDK or CLI. Read the Aurora documentation to learn more. For a complete list of regions where Parallel Query is offered, see Aurora Pricing.

Amazon 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 five times better throughput than standard MySQL together with increased scalability, durability, and security.

Amazon Aurora PostgreSQL Supports Rdkit Extension

Starting today, Amazon Aurora PostgreSQL supports the RDKit extension. The RDKit extension allows cheminformatics to deal with manipulation of chemical structures, fingerprinting search functions and molecular structure matching. Using PostgreSQL as a datastore, you can interact with several built-in functions to compare, manipulate and identify molecular structures via standard SQL.

RDKit is only supported for version 11.8 or higher. If you create the RDKit extension on a version prior to 11.8, you will need to drop and recreate it when you convert to 11.8. Please review the Aurora documentation to learn more. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide.  

Amazon 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. To get started with Amazon Aurora PostgreSQL, take a look at the getting started page.

Don't see an extension you'd like to use? Let us know through the AWS Forum, through your sales rep or TAM, or by emailing us at rds-postgres-extensions-request@amazon.com.  

Amazon Aurora Supports PostgreSQL 11.8, 10.13 and 9.6.18

Following the announcement of updates to the PostgreSQL database by the open source community, Amazon has updated Amazon Aurora with PostgreSQL compatibility to support PostgreSQL version 11.8, 10.13 and 9.6.18 in all regions. This release contains bug fixes and improvements by the PostgreSQL community, and improved TLS support from PostgreSQL 12.

Improvements in TLS support that were added in PostgreSQL 12 are now available in the Aurora PostgreSQL 11.8 minor version. This enhancement allows you to configure the minimum SSL/TLS protocol version for secure connections, which is becoming increasingly important as early versions of the TLS protocol (e.g., v1 and v1.1) have known security vulnerabilities. 

You can initiate a minor version upgrade manually by modifying your DB cluster. Or you can enable the* *“Auto minor version upgrade*” *option when creating or modifying a DB cluster. Doing so means that your DB cluster is automatically upgraded after Aurora PostgreSQL tests and approves the new version. For more details, see Automatic Minor Version Upgrades for PostgreSQL. Please review the Aurora documentation to learn more.  

Amazon 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. To get started with Amazon Aurora PostgreSQL, take a look at the getting started page.

« Back to Releases

Trustpilot