PostgreSQL 11 upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL
Database Blog
This article discusses upgrade strategies for Amazon Aurora PostgreSQL-Compatible Edition and Amazon RDS for PostgreSQL from version 11 to a newer major version, as PostgreSQL 11 will reach end of standard support on February 29, 2024.
Specifically, the article covers:
- End-of-life timeline for PostgreSQL 11 on AWS
- Major features in newer PostgreSQL versions like 15, 14, and 13
- Choosing a target version for upgrade (e.g. 15 recommended)
- Amazon RDS Extended Support for critical fixes after end of standard support
- Three upgrade options: in-place upgrade, Blue/Green deployment, and out-of-place upgrade
- Pros and cons of each upgrade approach to consider based on downtime vs complexity
- Recommendation to plan and test upgrades well before the end of support date
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
Feb 26
2025
2025
Upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL 12
Jan 27
2026
2026
Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13
Jan 23
2024
2024
Migrate rows with unique constraints to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL
Jan 26
2024
2024
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
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.