AWS Database Blog

Introduction to Aurora PostgreSQL cluster cache management

Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of Aurora delivers up to three times the throughput of standard PostgreSQL running on the same hardware. This enables existing PostgreSQL applications and tools to run […]

Read More

Migration tips for developers converting Oracle and SQL Server code to PostgreSQL

PostgreSQL is one of the most popular open-source relational database systems. It is considered to be one of the top database choices when customers migrate from commercial databases such as Oracle and Microsoft SQL Server. AWS provides two managed PostgreSQL options: Amazon RDS and Amazon Aurora. In addition to providing managed PostgreSQL services, AWS also […]

Read More

Disaster recovery on Amazon RDS for Oracle using AWS DMS

AWS Database Migration Service (AWS DMS) helps you migrate data from databases on-premises to Amazon Relational Database Service (RDS). You can also use it to migrate data between heterogeneous or homogeneous database engines, among other things. Businesses of all sizes use AWS to enable faster disaster recovery (DR) of their critical IT systems without having […]

Read More

Make a New Year’s resolution: Follow Amazon DynamoDB best practices

As the new year begins, we encourage you to make a resolution to follow Amazon DynamoDB best practices. Following these best practices can help you maximize performance and minimize throughput costs when working with DynamoDB. Click the following links to learn more about each best practice in the DynamoDB documentation. Design and use partition keys […]

Read More

Amazon Managed Blockchain recorded sessions and workshops from AWS re:Invent 2019

AWS re:Invent is always an exciting time to engage with our customers to learn more about their use cases, receive feedback for our services, and share information about our new features and capabilities. The Amazon Managed Blockchain team delivered several sessions and workshops, highlighting how customers are leveraging blockchain technology and diving deep into building […]

Read More

Best practices for upgrading Amazon RDS to major and minor versions of PostgreSQL

This post was updated on 03/2021 to fix RDS steps for upgrade. Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new engine versions within five months of their availability. You also must upgrade your RDS […]

Read More

Amazon DynamoDB–related videos and slide decks from AWS re:Invent 2019

This blog post includes links to videos and slide decks of the keynotes and Amazon DynamoDB–related sessions from AWS re:Invent 2019. Video recordings were not made of workshops, chalk talks, and builders sessions. As of the publication of this post, not all of the slide decks are available for download, but we will update this […]

Read More

Securing Amazon RDS and Aurora PostgreSQL database access with IAM authentication

AWS provides two managed PostgreSQL options: Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Both support IAM authentication for managing access to your database. You can associate database users with IAM users and roles to manage user access to all databases from a single location, which avoids issues caused by permissions being out of sync […]

Read More