AWS Database Blog

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

2019: The year in review for Amazon Neptune

Amazon Neptune celebrated its 18-month birthday last month. It has been a humbling experience to learn the innovative ways customers want to use graph. NBCUniversal is using Amazon Neptune to manage a graph for serving curated, personalized content. Thomson Reuters is using graph to understand complex regulatory models. Netflix has improved data infrastructure reliability by […]

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

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 PostgreSQL instances when a particular version is no longer supported. In this […]

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