Cannot upgrade RDS PostgreSQL 9.5 to 12.5
As we are forced to upgrade PostgreSQL 9.5 to 12.5, I have activated the maintenance upgrade which has started to work and also took the instance down for a while. After finishing it change status to Available however PostgreSQL version was still 9.5. There's no way for seeing what went wrong.
What should we do now?
I would say, starting point would be to check your RDS Events and may be logs as well. Before any upgrade, there is a PreUpgrade checks that happen and may be, those checks have failed for some reason which you can find in RDS Events of that instance.
did this help?
AWS automatic upgrade PostgreSQL version?asked a month ago
RDS PostgreSQL 11.1: high CPU and Write IOPS after upgrade?asked 3 years ago
Cannot upgrade replication engine 2.4.4 to anything higherasked 3 years ago
[Urgent Action Required] - Upgrade your RDS for PostgreSQL minor versionsasked 22 days ago
RDS PostgreSQL minor version upgrade wasn't performedasked 3 years ago
PostgreSQL RDS minor version upgrade stuck with "Incompatible-parameters"asked 3 years ago
Cannot upgrade RDS PostgreSQL 9.5 to 12.5asked 3 months ago
An unknown error on snapshot upgrade for PostgreSQLasked a month ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago
Aurora Postgres cluster failed to upgrade from 13.4 to 13.4.2 at maintenance windowasked a month ago