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

Webinar: Advanced Calendar Solution for Sugar Register

Amazon RDS September 2020 Update

Released on September 24th, 2020

Amazon RDS for PostgreSQL Supports new Minor Versions 12.4, 11.9, 10.14, 9.6.19, and 9.5.23

Following the announcement of updates to the PostgreSQL database, |Amazon has updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 12.4, 11.9, 10.14, 9.6.19, and 9.5.23. This release contains bug fixes and improvements done by the PostgreSQL community.  

This release adds support for RDKit, which allows molecules used in cheminformatics to be stored and retrieved via substructure and similarity searches, and updates aws s3 to allow Amazon RDS for PostgreSQL data queries to export results directly into an Amazon S3 bucket. This release also adds pg_proctab to query system statistics and updates pglogical, pgaudit, wal2json, and pg_transport. Please see the list of supported extensions in the Amazon RDS User Guide for specific versions.  

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. 

Amazon RDS M6g and R6g Instance Types, Powered by AWS Graviton2 Processors: In Preview and now Supported on More Database Versions

AWS Graviton2-based database instances in preview for Amazon Relational Database Service (RDS) now support more database versions. Graviton2 M6g and R6g database instances deliver better price performance over comparable current generation x86-based database instances. You can launch these database instances when using Amazon RDS for MySQL and Amazon RDS for PostgreSQL. With this launch, Graviton2 is now supported on RDS MySQL versions 8.0.17, 8.0.19, and 8.0.20 and RDS PostgreSQL 12.3, and 12.4. Support for Amazon Aurora and Amazon RDS for MariaDB is coming soon.

You can launch new instances in the Amazon RDS Management Console or using the AWS CLI. Upgrading a database instance to Graviton2 requires a simple instance type modification, using the same steps as any other instance modification. If you are currently on a relevant major version that is supported by Graviton2, such as RDS for MySQL 8.0.17, then you can move to Graviton2 by stopping the existing instance and changing the instance type to R6g or M6g instance using the AWS Management Console or AWS CLI. Your applications will continue to work as normal as you will not have to port any application code. For more details, refer to the documentation.  

The M6g and R6g database instances are now available in preview for Amazon RDS in the US East (N. Virginia, Ohio), US West (Oregon), Europe (Ireland, Frankfurt), and Asia Pacific (Mumbai, Singapore, Sydney, Tokyo) regions. 

Watch James Hamilton, VP and Distinguished Engineer at AWS, talk about AWS Graviton2 and open source databases. For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page. Review the technical documentation for more details.

Amazon RDS for SQL Server Now Supports SQL Server Reporting Services (SSRS) on SQL Server 2016

Amazon RDS for SQL Server now supports SQL Server Reporting Services (SSRS) on SQL Server 2016 (13.0058220.21.v1 and above), giving you the ability to host the report server web portal on the same Amazon RDS DB instance as your SQL Server database. There is no additional cost to install SSRS directly on your Amazon RDS DB instance.

If you are currently running SSRS on Amazon EC2, you can now save costs by running SSRS directly on the same RDS DB instance as your SQL Server database. SSRS is also already available on Amazon RDS for SQL Server 2017 on both the Standard and Enterprise editions.

Learn more about how to configure SSRS in RDS from this Blog post and see the Amazon Relational Database Services User Guide for more information.

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

Amazon RDS for SQL Server Now Supports Native Backup/Restore on DB Instances with Read Replicas

Amazon RDS for SQL Server now supports restoring SQL Server native backups onto DB instances that have read replicas configured. Previously, the read replica would need to be removed before restoring the native backup file onto your Amazon RDS for SQL Server DB instance. SQL Server backup files stored in your Amazon S3 bucket can now be restored directly on DB instances with read replicas.

To use SQL Server native backup/restore, you specify the S3 bucket that you want to use for storing the backup files. Grant RDS access to this bucket by creating an AWS IAM role, then associate the IAM role with your RDS DB instance.

To learn more about native backup/restore, see this blog post. To learn more about read replicas, see this blog post. Please visit the Amazon RDS for SQL Server User Guide to learn more.

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

Amazon RDS for SQL Server Now Supports More Time Zones

Amazon RDS for SQL Server now supports more time zones including South Africa Standard Time, Sri Lanka Standard Time, and UTC+13. This feature enables customers to match their DB instance time zone to their chosen time zone.

To set the time zone while creating a new RDS for SQL Server instance, use the Time zone menu in the AWS Management Console. The time zone can’t be modified once the instance has been created. Please note that this option changes the time zone at the OS level and impacts all date columns and values. Amazon recommends that you analyze your data to determine what impact a time zone change will have. Before creating a production DB instance with a local time zone, Amazon recommends you test the change in a development DB instance first.

To see the full list of supported time zones please visit the Amazon RDS for SQL Server User Guide.

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

PostgreSQL 13 Beta 3 now Available in Amazon RDS Database Preview Environment

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

PostgreSQL 13 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.  

The PostgreSQL community released PostgreSQL 13 Beta 3 on August 13, 2020. PostgreSQL 13 includes improved functionality and performance such as better duplicate data handling by B-tree indexes, improvements added to partitioning functionality, incremental sorting to accelerate data sorts, parallel processing of indexes with the VACUUM command, more ways to monitor activity within a PostgreSQL database, new security capabilities, and more.  

The Amazon RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (currently T3, M5, and R5), 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 13 and the Amazon RDS Database Preview Environment. 

« Back to Releases

Trustpilot