Automate Amazon Aurora PostgreSQL major or minor version upgrade using AWS Systems Manager and Amazon EC2
Database Blog
This article presents an automated solution for upgrading Amazon Aurora PostgreSQL clusters using AWS Systems Manager and EC2, reducing manual effort by up to 80%.
- Automates major and minor version upgrades across multiple Aurora PostgreSQL clusters
- Uses AWS Systems Manager to orchestrate upgrades with PREUPGRADE and UPGRADE modules
- Creates Copy-on-Write clones for safety backups before upgrades
- Identifies upgrade candidates using database tags for targeted automation
- Provides comprehensive logging to S3 and email notifications via SNS
- Requires EC2 instance in same VPC with AWS CLI, PostgreSQL client, and proper IAM permissions
- Supports both single and multi-cluster deployments with detailed pre-upgrade checks
The solution streamlines Aurora PostgreSQL version management through consistent, repeatable procedures with minimal human intervention and comprehensive monitoring throughout the upgrade process.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
May 28
2025
2025
Automate Amazon RDS for PostgreSQL major or minor version upgrade using AWS Systems Manager and Amazon EC2
Jan 27
2026
2026
Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13
Feb 26
2025
2025
Upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL 12
Jan 24
2024
2024
PostgreSQL 11 upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.