AWS Database Blog
Tag: Amazon RDS for PostgreSQL
Upgrading from Amazon RDS for PostgreSQL version 9.5
Updated on 02/18/2021 with more details about the automatic upgrade and its timeline. The PostgreSQL – community releases a new major version yearly, with a defined end of life (EOL) policy of older major versions. This allows you to make version and upgrade decisions well into the future. The community EOL policy is to support […]
Best practices for Amazon RDS for PostgreSQL cross-Region read replicas
October 2023: This post was reviewed and updated for accuracy. One of the managed service offerings of Amazon RDS for PostgreSQL is cross-Region read replicas. Cross-Region read replicas enable you to have a disaster recovery solution, scaling read database workload, and cross-Region migration. You can create a cross-Region read replica by using the Amazon RDS […]
Migrating PostgreSQL from on-premises or Amazon EC2 to Amazon RDS using logical replication
PostgreSQL is one of the most advanced popular open-source relational database systems. With more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complicated data workloads. For many, PostgreSQL is the open-source database of choice when migrating from commercial databases […]
Multi-tenant data isolation with PostgreSQL Row Level Security
Isolating tenant data is a fundamental responsibility for Software as a Service (SaaS) providers. If one of your tenants gains access to another tenant’s data, you lose trust and may permanently damage your brand or worse, lose your business. With the risks so great, it is critical to have an effective data isolation plan. […]
Recap of Amazon RDS and Aurora features launched in 2019
Updated 04/2022 to reflect product changes. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity. At the same time, it automates time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups. It frees you to […]