Major version upgrades to PostgreSQL 15 or later in RDS and Aurora can stall or roll back if circular role dependencies exist. AWS provides a specific pre-upgrade query to detect these problematic configurations. Resolving these dependencies beforehand ensures a smooth upgrade path without interruption.
- Upgrades to PostgreSQL 15+ may fail due to circular role dependencies
- Run the provided pre-upgrade query to detect existing cycles
- Clear identified dependencies before initiating the major version upgrade
- Pre-check prevents automatic rollback and service interruption
Fleet impact: RDS/Aurora PostgreSQL DBAs must run the pre-upgrade detection query before scheduling any major version upgrade to PostgreSQL 15+. Circular role dependencies will cause upgrade failures or rollbacks, so identifying and resolving them is a critical prerequisite step.