Posted On: Dec 11, 2024

Amazon Relational Database Service (Amazon RDS) Blue/Green Deployments now supports safer, simpler, and faster minor version upgrades for your Amazon RDS for PostgreSQL databases. Blue/Green Deployments for PostgreSQL creates a fully managed staging environment using physical replication for minor version upgrades, that allows you to deploy and test production changes, keeping your current production database safer. With a few clicks, you can switchover the staging environment to be the new production system in as fast as a minute, with no data loss and no changes to your application for database endpoint management.  

You can now use Amazon RDS Blue/Green Deployments for deploying multiple database changes to production such as minor version upgrades, maintenance updates, and scaling instances in a single switchover event using physical replication. The use of PostgreSQL physical replication for database change management, such as minor version upgrade, simplifies your RDS Blue/Green Deployments upgrade experience by overcoming PostgreSQL community logical replication limitations. Learn more about PostgreSQL community logical replication here. RDS Blue/Green Deployments for PostgreSQL relies on logical replication for major version upgrades.  

Amazon RDS Blue/Green Deployments is now available for Amazon RDS for PostgreSQL for versions 12.15 and higher, 13.11 and higher, 14.9 and higher, 15.4 and higher, and 16.1 and higher in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD.  

In a few clicks, update your databases using Amazon RDS Blue/Green Deployments via the Amazon RDS Management Console. Learn more about Blue/Green Deployments on the Amazon RDS features page.