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

Webinar: Use Sugar Data to Easily Generate Complex Documents Register

Webinar: Advanced Calendar Solution for Sugar Register

Amazon RDS August 2019 Update

Released on August 28th, 2019

PostgreSQL 12 Beta 3 Now Available in Amazon RDS Database Preview Environment

PostgreSQL 12 Beta 3 is now available in the Amazon RDS Database Preview Environment, allowing customers to test the beta version of PostgreSQL 12 on Amazon RDS

PostgreSQL 12 Beta 3 can now be deployed for development and testing in the Amazon RDS Database Preview Environment without the hassle of installing, provisioning, and managing the database. This release includes support for a number of extensions including PostGIS 3.0.0alpha3. This release also adds wal2json and decoder_raw output plugins for logical decoding in PostgreSQL 12. 

The PostgreSQL community released PostgreSQL 12 Beta 3 on August 8, 2019. PostgreSQL 12 includes improved functionality, performance, management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations which 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, pluggable table storage interface, ability to enable/disable page checksums, and many more. 

The Amazon RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (currently T2, M4, and R4), and can be encrypted at rest using KMS keys. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. Customers can use standard PostgreSQL dump and load functionality to import or export their databases from the preview environment. 

Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region. 

The Amazon RDS Database Preview Environment Forum is available for customers and the Amazon RDS team to share information and concerns about both the candidate versions of PostgreSQL 12 and the Amazon RDS Database Preview Environment. 

Amazon RDS for MySQL Supports Minor Version 8.0.16

Amazon RDS for MySQL has been updated to support release 8.0.16 of the MySQL database. This release includes a number of security, account management, and other functionality improvements, along with a number of bug fixes.

To use the new version, you can create a new Amazon RDS database instance with just a few clicks in the Amazon RDS Management Console, or modify an existing instance using a point-and-click upgrade. See the documentation for more information about MySQL versions and upgrade procedures. 

Amazon RDS for MySQL makes it easy to set up, operate, and scale MySQL deployments in the cloud. See Amazon RDS for MySQL Pricing for regional availability. 

Amazon RDS now supports Oracle Database 18c

You can now launch Amazon RDS instances for Oracle Database 18c.  

Oracle Database 18c introduces many new features such as Polymorphic Table Functions, Schema Only Accounts, Scalable Sequences, and others. 

A Polymorphic Table Function (PTF) is a type of table function whose return type is determined by the arguments passed into the PTF. This is ideal for developers if they want to provide generic extensions that support arbitrary input tables or queries. You can create Schema Only Accounts, for object ownership without allowing clients to log in to the schema. Scalable Sequences reduce the sequence and index block contention and can improve the performance of concurrent data ingestion workloads, especially when the sequence values are used for populating unordered primary or unique keys.  

To create a new Oracle Database 18c RDS instance with just a few clicks in the AWS Management Console, use the "Launch DB Instance" wizard and select the DB engine version "Oracle 18.0.0.0.ru-2019-07.rur-2019-07.r1" (contains the July 2019 Release Update). Amazon RDS for Oracle also supports major version upgrade from 11.2.0.4, 12.1.0.2 and 12.2.0.1 to 18c. To upgrade your existing RDS for Oracle instances to 18c with just a few clicks from "Modify DB Instance Wizard" in the AWS Management Console, select the DB Engine version "18.0.0.0.ru-2019-07.rur-2019-07.r1". 

Learn more by visiting the Amazon RDS for Oracle 18c feature overview and release notes.

Please visit Amazon RDS for Oracle Pricing for complete regional availability information. 

PostgreSQL 11 and New PostgreSQL Minor Versions 11.4, 10.9, 9.6.14, 9.5.18, and 9.4.23 Now Supported in Amazon RDS for AWS GovCloud (US) Regions

Amazon RDS now supports PostgreSQL major version 11 in AWS GovCloud (US) Regions. PostgreSQL 11 includes major improvements to partitioning, improvements to parallelism, and many other useful performance improvements like adding columns with a non-null column default faster. This version includes SQL stored procedures that allow embedded transactions within a procedure. 

Following the announcement of updates to the PostgreSQL database, Amazon has updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11.4, 10.9, 9.6.14, 9.5.18 and 9.4.23. This release contains cumulative fixes including an important security fix, bug fixes and other improvements done by the PostgreSQL community.  

PostgreSQL extension pgaudit has been updated to 1.3.0, to 1.3.2, pglogical to 2.2.1, PLV8 to 2.3.8, PostGIS to 2.5.1, prefix to 1.2.8, and wal2json to hash 9e962ba. A new extension pgTAP, a suite of database functions that make it easy to write unit tests in psql script, is added and supported with PostgreSQL version 11.2 and above. Extension pg_hint_plan has been updated to 1.3.2 for PostgreSQL versions 11, 10, 9.6 and 9.5. Please refer to the documentation for the various extensions and modules supported in various RDS PostgreSQL versions. 

Amazon S3 Import feature is now available for PostgreSQL version 11.1, and 10.7 and later versions. Multi Major Version Upgrades for PostgreSQL feature is now supported which allows you to perform major version upgrades across multiple different major versions. Please refer to the major version upgrade documentation on details around the PostgreSQL versions that are supported as source and target versions and also any limitations associated with the upgrade process. 

To use the new version, you can create a new Amazon RDS for PostgreSQL database instance with just a few clicks in the AWS GovCloud Management Console. Learn about upgrading your instances in the Amazon RDS for PostgreSQL User Guide. 

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 details and regional availability. 

Amazon RDS for Oracle Now supports July 2019 Oracle Patch Set Updates (PSU) and Release Updates (RU)

Amazon RDS for Oracle now supports the July 2019 Patch Set Updates (PSU) for Oracle Database 11.2 and 12.1, and July 2019 Release Update (RU) for Oracle Database 12.2.

Oracle PSUs contain bug fixes and other critical security updates. Beginning with Oracle Database version 12.2.0.1, Amazon RDS for Oracle supports Release Updates (RU) in place of the PSU. To learn more about the Oracle PSUs supported on Amazon RDS, please visit the Amazon RDS patch update documentation

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See the Amazon RDS for Oracle Database Pricing page for complete regional availability information.

Amazon RDS for Oracle Supports Oracle Management Agent (OMA) version 13.3 for Oracle Enterprise Manager Cloud Control 13c

Amazon RDS for Oracle now supports Oracle Management Agent (OMA) version 13.3 for Oracle Enterprise Manager (OEM) Cloud Control 13c3. OEM 13c offers web-based tools to monitor and manage your Oracle databases. Amazon RDS for Oracle installs OMA, which then communicates with your Oracle Management Service (OMS) to provide monitoring information. Customers running OMS 13.3 can now manage databases by installing OMA 13.3.

To enable the version 13.3 of Oracle Management Agent (OMA) for OEM 13c, navigate to "Option Groups" in the AWS Management Console and add the "OEM_AGENT" option to a new or existing option group and set AGENT_VERSION to “13.3.0.0.v1”. You will also need to configure option settings including OMS hostname (or IP), port and agent registration password to allow OMA on your Amazon RDS for Oracle database instances to communicate with your existing Oracle Management Service (OMS) stack. To learn more about enabling OEM 13c, please refer to Amazon RDS for Oracle documentation

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See Amazon RDS for Oracle Database Pricing for regional availability. 

PostgreSQL 12 Beta 2 Now Available in Amazon RDS Database Preview Environment

PostgreSQL 12 Beta 2 is now available in the Amazon RDS Database Preview Environment, allowing customers to test the beta version of PostgreSQL 12 on Amazon RDS.

PostgreSQL 12 Beta 2 can now be deployed for development and testing in the Amazon RDS Database Preview Environment without the hassle of installing, provisioning, and managing the database. The PostgreSQL community released PostgreSQL 12 Beta 2 on June 20, 2019. PostgreSQL 12 includes improved functionality, performance, management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations which 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, pluggable table storage interface, ability to enable/disable page checksums, and many more.

The Amazon RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (currently T2, M4, and R4), and can be encrypted at rest using KMS keys. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. Customers can use standard PostgreSQL dump and load functionality to import or export their databases from the preview environment.

Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region.

The Amazon RDS Database Preview Environment Forum is available for customers and the Amazon RDS team to share information and concerns about both the candidate versions of PostgreSQL 12 and the Amazon RDS Database Preview Environment.

Amazon RDS SQL Server Now Supports Changing the Server-Level Collation

Amazon RDS for SQL Server now supports changing the server-level collation when creating a new DB Instance. If the collation is not specified the default server-level collation will continue to be SQL_Latin1_General_CP1_CI_AS. To learn more about which collations are supported please visit the Amazon RDS for SQL Server User Guide

Please refer to Amazon RDS Pricing for pricing and regional availability. 

Amazon RDS for Oracle Now Supports New Instance Sizes

Starting today, Amazon RDS for Oracle db.m5 and db.r5 instance classes are available in new 8xlarge and 16xlarge sizes. With support for these new instance sizes, customers who are currently using either m4.10xlarge, m4.16xlarge, r4.8xlarge, or r4.16xlarge now have an easy upgrade path to the latest generation of instances. 

M5 instances are the latest generation of general purpose instances and provide improved performance over current generation M4 instances. The M5 instance family provides a balance of compute, memory, and network resources, and is a good choice for many database workloads. 

R5 instances are the latest generation of memory optimized instances that deliver 5% additional memory per vCPU and up to 20% increased CPU performance over R4 instances. R5 instances are well suited for running memory intensive database workloads including transaction processing, data warehousing, and analytics.

To get started, visit the AWS Management ConsoleAWS RDS Command Line Interface (CLI), and AWS RDS API. To learn more about pricing and regional availability, refer to the Amazon RDS for Oracle pricing page

« Back to Releases

Trustpilot